AirBNB Seattle Data Analysis¶

Introduction:¶

This project is to demonstrate the understanding of data science process and to apply it real data set.
The data set I chose is provided by AirBNB, the house sharing company for the West Coast City of Seattle,
I will follow CRISP-DM process in the analysis of this data set.

Data Sets:¶

The data is divided in three files:

calendar.csv - containing listing prices and data about availability
listings.csv - the main data file, which contains detailed features about each listing
reviews.csv - records for listing reviews

Business understanding:¶

The data have many features to analyze, I will choose the ones related to customers and neighborhoods.
I will do some data exploration and visualizations to answer the following questions:
Q1: Are Customers Happy?
Q2: Where listings are concentrated?
Q3: How much the customer is paying to stay in Seattle with AirBNB?
Q4: What are the average prices for each neighborhood?

# import libraries here; add more as necessary
import numpy as np
import pandas as pd
import math
import json
import pickle
from datetime import datetime as dt
from IPython.display import display, HTML
import plotly
import re
import ast




import sys
np.set_printoptions(threshold=sys.maxsize)
print(sys.version)

pd.set_option('display.max_columns', 500)
import chart_studio as py
import plotly.graph_objects as go
import plotly.io as pio
import plotly.express as px

3.7.3 (default, Mar 27 2019, 22:11:17) 
[GCC 7.3.0]

Data understanding:¶

Here I will load each of the files and do some exploration

# read in the csv files
calendar = pd.read_csv('calendar.csv')
listings = pd.read_csv('listings.csv')
reviews = pd.read_csv('reviews.csv')

calendar

listings

listings.describe()

reviews

review_scores = ['id', 'review_scores_rating', 'review_scores_accuracy', 'review_scores_cleanliness', 'review_scores_checkin', 'review_scores_communication', 'review_scores_location', 'review_scores_value', 'number_of_reviews']

listings_reviews = listings[review_scores]

listings_reviews

listings_reviews.describe()

listings_reviews.dropna(inplace=True)

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

listings_reviews

review_scores[1:]

['review_scores_rating',
 'review_scores_accuracy',
 'review_scores_cleanliness',
 'review_scores_checkin',
 'review_scores_communication',
 'review_scores_location',
 'review_scores_value',
 'number_of_reviews']

Q1: Are Customers Happy?¶

First, we want to make sure the customer is having good time while staying with AirBNB Host:

fig = go.Figure()
for i in review_scores[2:-1]:
    fig.add_trace(go.Histogram(x=listings_reviews[i],name=i))

# Overlay both histograms
fig.update_layout(title = 'Review Scores For Each Category', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()

As we can see from the graph above most of the reviews are excellent, which means the customers are happy.

Data preparation:¶

Here I will clean some features in the listings data set, for further investigations.
I will start by writing a function for host features cleaning.

def clean_host_feature(listings):
    '''
    Description: This function is used to clean and select the features 
                 related to host data in the listings data set.

    Arguments:
        AirBNB listings dataframe.

    Returns:
        Cleaned dataframe with only host related features.
    '''

    host_features = ['host_response_rate', 'host_acceptance_rate', 'host_is_superhost', 'host_thumbnail_url', 'host_picture_url', 'host_neighbourhood', 'host_listings_count', 'host_total_listings_count', 'host_verifications', 'host_has_profile_pic', 'host_identity_verified']
    listings_host_features = listings[host_features]
    listings_host_features['host_thumbnail_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_thumbnail_url']) else 1, axis=1)
    listings_host_features['host_picture_url'] = listings_host_features.apply(lambda x: 0 if pd.isna(x['host_picture_url']) else 1, axis=1)
    listings_host_features['host_has_profile_pic'] = listings_host_features.apply(lambda x: 1 if x['host_has_profile_pic']=='t' else 0, axis=1)
    listings_host_features['host_identity_verified'] = listings_host_features.apply(lambda x: 1 if x['host_identity_verified']=='t' else 0, axis=1)
    listings_host_features['host_verifications'] = listings_host_features.apply(lambda x: ast.literal_eval(x['host_verifications']), axis=1)
    return listings_host_features

listings_host_features = clean_host_feature(listings)

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:15: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:16: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:17: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:18: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:19: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

listings_host_features

Now I will prepare the locations data set:

locations = ['id','latitude', 'longitude', 'neighbourhood', 'street','is_location_exact']

listings_locations = listings[locations]

listings_locations = listings_locations[listings_locations['is_location_exact']=='t'].drop('is_location_exact',axis=1)

listings_locations['listing_id']=listings_locations['id']

listings_locations=listings_locations.drop('id',axis=1)

listings_locations

Q2: Where listings are concentrated?¶

Second, we want to know what neighbourhoods are most popular.

fig = go.Figure()
fig.add_trace(go.Histogram(x=listings_locations['neighbourhood'],name='neighbourhood'))

# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listings Distribution Per Neighbourhood', barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()

listings_locations.groupby('neighbourhood')['neighbourhood'].count().nlargest()

neighbourhood
Capitol Hill    341
Ballard         208
Minor           189
Belltown        185
Queen Anne      185
Name: neighbourhood, dtype: int64

The most popular listings neighbourhood is: Capitol Hill.
Then almost equally popular: Ballard, Minor, Belltown, Queen Anne

fig = go.Figure(data=go.Scattergeo(
        lon = listings_locations['longitude'],
        lat = listings_locations['latitude'],
        text = listings_locations['neighbourhood'],
        ))

fig.update_layout(
        title = 'Seattle AirBNB Listings Locations Map',
        geo_scope='usa',
    )
fig.show()

Q3: How much the customer is paying to stay in Seattle with AirBNB?¶

Then, we will explore the price distribution for Seattle listing.

calendar['price']

0          $85.00
1          $85.00
2             NaN
3             NaN
4             NaN
5             NaN
6             NaN
7             NaN
8             NaN
9          $85.00
10         $85.00
11            NaN
12            NaN
13            NaN
14         $85.00
15         $85.00
16         $85.00
17            NaN
18            NaN
19            NaN
20         $85.00
21         $85.00
22         $85.00
23         $85.00
24         $85.00
25            NaN
26            NaN
27            NaN
28         $85.00
29         $85.00
            ...  
1393540       NaN
1393541       NaN
1393542       NaN
1393543       NaN
1393544       NaN
1393545       NaN
1393546       NaN
1393547       NaN
1393548       NaN
1393549       NaN
1393550       NaN
1393551       NaN
1393552       NaN
1393553       NaN
1393554       NaN
1393555       NaN
1393556       NaN
1393557       NaN
1393558       NaN
1393559       NaN
1393560       NaN
1393561       NaN
1393562       NaN
1393563       NaN
1393564       NaN
1393565       NaN
1393566       NaN
1393567       NaN
1393568       NaN
1393569       NaN
Name: price, Length: 1393570, dtype: object

prices = calendar.dropna()
prices['price'] = prices.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)

/home/hp/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:2: SettingWithCopyWarning:


A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

fig = go.Figure()
fig.add_trace(go.Histogram(x=prices['price'],name='price'))

# Overlay both histograms
fig.update_layout(title = 'Seattle AirBNB Listing Price Distribution',barmode='overlay')
# Reduce opacity to see both histograms
fig.update_traces(opacity=0.75)
fig.show()

prices['price'].describe()

count    934542.000000
mean        137.944859
std         105.062870
min          10.000000
25%          75.000000
50%         109.000000
75%         160.000000
max        1650.000000
Name: price, dtype: float64

it is clear that the average price is 137, with highest count for 150 range

Q4: What are the average prices for each neighborhood?¶

Then, we will explore the price distribution for each neighbourhood.

listings_locations_calendar_merged = pd.merge(listings_locations , calendar, on='listing_id', how='outer').dropna()

listings_locations_calendar_merged = listings_locations_calendar_merged[listings_locations_calendar_merged['available']=='t'].drop(['date','available'],axis=1)

listings_locations_calendar_merged['price'] = listings_locations_calendar_merged.apply(lambda x: float(x['price'].replace('$','').replace(',','')), axis=1)

listings_locations_calendar_merged

df = listings_locations_calendar_merged.groupby('neighbourhood').mean()
fig = px.bar(df, y=df.price, x=df.index, text=df.price)
fig.update_traces(texttemplate='%{text:.2s}', textposition='outside')
fig.update_layout(title = 'Seattle AirBNB Listing Average Prices For Each Neighbourhood', uniformtext_minsize=8, uniformtext_mode='hide')
fig.show()

listings_locations_calendar_merged.groupby('neighbourhood')['price'].mean().nlargest(50)

neighbourhood
Portage Bay                  250.885285
Industrial District          245.875441
Windermere                   227.516092
Alki                         226.410733
Westlake                     225.336634
Central Business District    210.509103
Fauntleroy                   205.882353
Magnolia                     205.523503
Pike Place Market            204.686803
Belltown                     201.061400
Pike Market                  192.582019
Queen Anne                   190.648790
South Lake Union             186.288490
Pinehurst                    181.668142
Madrona                      166.367724
Green Lake                   164.928139
Montlake                     163.139629
Lower Queen Anne             158.929664
First Hill                   155.947990
North Admiral                155.736659
Pioneer Square               154.067182
Madison Park                 145.502389
Fremont                      141.962528
Seaview                      141.670207
Yesler Terrace               141.037221
Minor                        135.778037
Capitol Hill                 135.456855
Broadway                     134.753425
Leschi                       133.423488
Wallingford                  131.802042
South Beacon Hill            131.321212
South Park                   128.338863
Arbor Heights                127.230769
Phinney Ridge                126.478765
Harrison/Denny-Blaine        126.464454
Ballard                      125.943331
Atlantic                     125.779920
View Ridge                   124.224777
North Beach/Blue Ridge       122.300155
Haller Lake                  121.955873
Genesee                      121.610086
Gatewood                     118.250151
Cedar Park                   118.203544
Roosevelt                    117.941571
International District       116.072308
Ravenna                      115.721137
Stevens                      115.673542
Laurelhurst                  114.084595
Interbay                     113.081671
Eastlake                     111.225513
Name: price, dtype: float64

The most expensive listings neighbourhoods are: Portage Bay and Industrial District .
Then almost equally expensive: Alki,Westlake and Central Business District

Results and Evaluation:¶

The most expensive listings neighbourhoods are not the most popular listings. Popular listings are more in the mid range prices like the most popular listing Capitol Hill, which hase mean price of 135.

	listing_id	date	available	price
0	241032	2016-01-04	t	$85.00
1	241032	2016-01-05	t	$85.00
2	241032	2016-01-06	f	NaN
3	241032	2016-01-07	f	NaN
4	241032	2016-01-08	f	NaN
5	241032	2016-01-09	f	NaN
6	241032	2016-01-10	f	NaN
7	241032	2016-01-11	f	NaN
8	241032	2016-01-12	f	NaN
9	241032	2016-01-13	t	$85.00
10	241032	2016-01-14	t	$85.00
11	241032	2016-01-15	f	NaN
12	241032	2016-01-16	f	NaN
13	241032	2016-01-17	f	NaN
14	241032	2016-01-18	t	$85.00
15	241032	2016-01-19	t	$85.00
16	241032	2016-01-20	t	$85.00
17	241032	2016-01-21	f	NaN
18	241032	2016-01-22	f	NaN
19	241032	2016-01-23	f	NaN
20	241032	2016-01-24	t	$85.00
21	241032	2016-01-25	t	$85.00
22	241032	2016-01-26	t	$85.00
23	241032	2016-01-27	t	$85.00
24	241032	2016-01-28	t	$85.00
25	241032	2016-01-29	f	NaN
26	241032	2016-01-30	f	NaN
27	241032	2016-01-31	f	NaN
28	241032	2016-02-01	t	$85.00
29	241032	2016-02-02	t	$85.00
...	...	...	...	...
1393540	10208623	2016-12-04	f	NaN
1393541	10208623	2016-12-05	f	NaN
1393542	10208623	2016-12-06	f	NaN
1393543	10208623	2016-12-07	f	NaN
1393544	10208623	2016-12-08	f	NaN
1393545	10208623	2016-12-09	f	NaN
1393546	10208623	2016-12-10	f	NaN
1393547	10208623	2016-12-11	f	NaN
1393548	10208623	2016-12-12	f	NaN
1393549	10208623	2016-12-13	f	NaN
1393550	10208623	2016-12-14	f	NaN
1393551	10208623	2016-12-15	f	NaN
1393552	10208623	2016-12-16	f	NaN
1393553	10208623	2016-12-17	f	NaN
1393554	10208623	2016-12-18	f	NaN
1393555	10208623	2016-12-19	f	NaN
1393556	10208623	2016-12-20	f	NaN
1393557	10208623	2016-12-21	f	NaN
1393558	10208623	2016-12-22	f	NaN
1393559	10208623	2016-12-23	f	NaN
1393560	10208623	2016-12-24	f	NaN
1393561	10208623	2016-12-25	f	NaN
1393562	10208623	2016-12-26	f	NaN
1393563	10208623	2016-12-27	f	NaN
1393564	10208623	2016-12-28	f	NaN
1393565	10208623	2016-12-29	f	NaN
1393566	10208623	2016-12-30	f	NaN
1393567	10208623	2016-12-31	f	NaN
1393568	10208623	2017-01-01	f	NaN
1393569	10208623	2017-01-02	f	NaN

	id	listing_url	scrape_id	last_scraped	name	summary	space	description	experiences_offered	neighborhood_overview	notes	transit	thumbnail_url	medium_url	picture_url	xl_picture_url	host_id	host_url	host_name	host_since	host_location	host_about	host_response_time	host_response_rate	host_acceptance_rate	host_is_superhost	host_thumbnail_url	host_picture_url	host_neighbourhood	host_listings_count	host_total_listings_count	host_verifications	host_has_profile_pic	host_identity_verified	street	neighbourhood	neighbourhood_cleansed	neighbourhood_group_cleansed	city	state	zipcode	market	smart_location	country_code	country	latitude	longitude	is_location_exact	property_type	room_type	accommodates	bathrooms	bedrooms	beds	bed_type	amenities	square_feet	price	weekly_price	monthly_price	security_deposit	cleaning_fee	guests_included	extra_people	minimum_nights	maximum_nights	calendar_updated	has_availability	availability_30	availability_60	availability_90	availability_365	calendar_last_scraped	number_of_reviews	first_review	last_review	review_scores_rating	review_scores_accuracy	review_scores_cleanliness	review_scores_checkin	review_scores_communication	review_scores_location	review_scores_value	requires_license	license	jurisdiction_names	instant_bookable	cancellation_policy	require_guest_profile_picture	require_guest_phone_verification	calculated_host_listings_count	reviews_per_month
0	241032	https://www.airbnb.com/rooms/241032	20160104002432	2016-01-04	Stylish Queen Anne Apartment	NaN	Make your self at home in this charming one-be...	Make your self at home in this charming one-be...	none	NaN	NaN	NaN	NaN	NaN	https://a1.muscache.com/ac/pictures/67560560/c...	NaN	956883	https://www.airbnb.com/users/show/956883	Maija	2011-08-11	Seattle, Washington, United States	I am an artist, interior designer, and run a s...	within a few hours	96%	100%	f	https://a0.muscache.com/ac/users/956883/profil...	https://a0.muscache.com/ac/users/956883/profil...	Queen Anne	3.0	3.0	['email', 'phone', 'reviews', 'kba']	t	t	Gilman Dr W, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.636289	-122.371025	t	Apartment	Entire home/apt	4	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$85.00	NaN	NaN	NaN	NaN	2	$5.00	1	365	4 weeks ago	t	14	41	71	346	2016-01-04	207	2011-11-01	2016-01-02	95.0	10.0	10.0	10.0	10.0	9.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	2	4.07
1	953595	https://www.airbnb.com/rooms/953595	20160104002432	2016-01-04	Bright & Airy Queen Anne Apartment	Chemically sensitive? We've removed the irrita...	Beautiful, hypoallergenic apartment in an extr...	Chemically sensitive? We've removed the irrita...	none	Queen Anne is a wonderful, truly functional vi...	What's up with the free pillows? Our home was...	Convenient bus stops are just down the block, ...	https://a0.muscache.com/ac/pictures/14409893/f...	https://a0.muscache.com/im/pictures/14409893/f...	https://a0.muscache.com/ac/pictures/14409893/f...	https://a0.muscache.com/ac/pictures/14409893/f...	5177328	https://www.airbnb.com/users/show/5177328	Andrea	2013-02-21	Seattle, Washington, United States	Living east coast/left coast/overseas. Time i...	within an hour	98%	100%	t	https://a0.muscache.com/ac/users/5177328/profi...	https://a0.muscache.com/ac/users/5177328/profi...	Queen Anne	6.0	6.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	7th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.639123	-122.365666	t	Apartment	Entire home/apt	4	1.0	1.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Free...	NaN	$150.00	$1,000.00	$3,000.00	$100.00	$40.00	1	$0.00	2	90	today	t	13	13	16	291	2016-01-04	43	2013-08-19	2015-12-29	96.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	t	t	6	1.48
2	3308979	https://www.airbnb.com/rooms/3308979	20160104002432	2016-01-04	New Modern House-Amazing water view	New modern house built in 2013. Spectacular s...	Our house is modern, light and fresh with a wa...	New modern house built in 2013. Spectacular s...	none	Upper Queen Anne is a charming neighborhood fu...	Our house is located just 5 short blocks to To...	A bus stop is just 2 blocks away. Easy bus a...	NaN	NaN	https://a2.muscache.com/ac/pictures/b4324e0f-a...	NaN	16708587	https://www.airbnb.com/users/show/16708587	Jill	2014-06-12	Seattle, Washington, United States	i love living in Seattle. i grew up in the mi...	within a few hours	67%	100%	f	https://a1.muscache.com/ac/users/16708587/prof...	https://a1.muscache.com/ac/users/16708587/prof...	Queen Anne	2.0	2.0	['email', 'phone', 'google', 'reviews', 'jumio']	t	t	West Lee Street, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.629724	-122.369483	t	House	Entire home/apt	11	4.5	5.0	7.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$975.00	NaN	NaN	$1,000.00	$300.00	10	$25.00	4	30	5 weeks ago	t	1	6	17	220	2016-01-04	20	2014-07-30	2015-09-03	97.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	2	1.15
3	7421966	https://www.airbnb.com/rooms/7421966	20160104002432	2016-01-04	Queen Anne Chateau	A charming apartment that sits atop Queen Anne...	NaN	A charming apartment that sits atop Queen Anne...	none	NaN	NaN	NaN	NaN	NaN	https://a0.muscache.com/ac/pictures/94146944/6...	NaN	9851441	https://www.airbnb.com/users/show/9851441	Emily	2013-11-06	Seattle, Washington, United States	NaN	NaN	NaN	NaN	f	https://a2.muscache.com/ac/users/9851441/profi...	https://a2.muscache.com/ac/users/9851441/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'jum...	t	t	8th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.638473	-122.369279	t	Apartment	Entire home/apt	3	1.0	0.0	2.0	Real Bed	{Internet,"Wireless Internet",Kitchen,"Indoor ...	NaN	$100.00	$650.00	$2,300.00	NaN	NaN	1	$0.00	1	1125	6 months ago	t	0	0	0	143	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
4	278830	https://www.airbnb.com/rooms/278830	20160104002432	2016-01-04	Charming craftsman 3 bdm house	Cozy family craftman house in beautiful neighb...	Cozy family craftman house in beautiful neighb...	Cozy family craftman house in beautiful neighb...	none	We are in the beautiful neighborhood of Queen ...	Belltown	The nearest public transit bus (D Line) is 2 b...	NaN	NaN	https://a1.muscache.com/ac/pictures/6120468/b0...	NaN	1452570	https://www.airbnb.com/users/show/1452570	Emily	2011-11-29	Seattle, Washington, United States	Hi, I live in Seattle, Washington but I'm orig...	within an hour	100%	NaN	f	https://a0.muscache.com/ac/users/1452570/profi...	https://a0.muscache.com/ac/users/1452570/profi...	Queen Anne	2.0	2.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	14th Ave W, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.632918	-122.372471	t	House	Entire home/apt	6	2.0	3.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$450.00	NaN	NaN	$700.00	$125.00	6	$15.00	1	1125	7 weeks ago	t	30	60	90	365	2016-01-04	38	2012-07-10	2015-10-24	92.0	9.0	9.0	10.0	10.0	9.0	9.0	f	NaN	WASHINGTON	f	strict	f	f	1	0.89
5	5956968	https://www.airbnb.com/rooms/5956968	20160104002432	2016-01-04	Private unit in a 1920s mansion	We're renting out a small private unit of one ...	If you include a bit of your background in you...	We're renting out a small private unit of one ...	none	This part of Queen Anne has wonderful views an...	Let me know if you need anything or have sugge...	The #1 and #2 bus picks up 2-3 blocks away (di...	https://a2.muscache.com/ac/pictures/84791950/f...	https://a2.muscache.com/im/pictures/84791950/f...	https://a2.muscache.com/ac/pictures/84791950/f...	https://a2.muscache.com/ac/pictures/84791950/f...	326758	https://www.airbnb.com/users/show/326758	Andrew	2010-12-25	Seattle, Washington, United States	I've been fortunate to have had many life expe...	NaN	NaN	NaN	f	https://a2.muscache.com/ac/users/326758/profil...	https://a2.muscache.com/ac/users/326758/profil...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	West Comstock Street, Seattle, WA 98119, Unite...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.630525	-122.366174	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet","Free Parking on Premises...	NaN	$120.00	$800.00	NaN	NaN	$40.00	1	$30.00	1	6	2 weeks ago	t	0	0	27	302	2016-01-04	17	2015-06-11	2015-09-28	95.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	2.45
6	1909058	https://www.airbnb.com/rooms/1909058	20160104002432	2016-01-04	Queen Anne Private Bed and Bath	Enjoy a quiet stay in our comfortable 1915 Cra...	Enjoy a quiet stay in our comfortable 1915 Cra...	Enjoy a quiet stay in our comfortable 1915 Cra...	none	Close restaurants, coffee shops and grocery st...	The room now has a mini frig to keep your favo...	The bus goes through the lower Queen Anne neig...	https://a2.muscache.com/ac/pictures/26505642/2...	https://a2.muscache.com/im/pictures/26505642/2...	https://a2.muscache.com/ac/pictures/26505642/2...	https://a2.muscache.com/ac/pictures/26505642/2...	2497928	https://www.airbnb.com/users/show/2497928	Gary And Beth	2012-05-30	Seattle, Washington, United States	We have lived in the the Queen Anne neighborho...	within an hour	100%	100%	t	https://a0.muscache.com/ac/users/2497928/profi...	https://a0.muscache.com/ac/users/2497928/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	10th Avenue West, Seattle, WA 98119, United St...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.636605	-122.368519	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet","Free Parking on Premises...	NaN	$80.00	$575.00	NaN	$150.00	NaN	1	$10.00	3	14	5 weeks ago	t	20	49	71	346	2016-01-04	58	2014-01-27	2015-12-07	99.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	2.46
7	856550	https://www.airbnb.com/rooms/856550	20160104002432	2016-01-04	Tiny Garden cabin on Queen Anne	Our tiny cabin is private , very quiet and com...	This cabin was built with Airbnb in mind, Que...	Our tiny cabin is private , very quiet and com...	none	We are centrally located between Downtown and ...	There are three rentals in our back yard . If ...	the "D" line runs out in front of our house .	https://a2.muscache.com/ac/pictures/83538305/d...	https://a2.muscache.com/im/pictures/83538305/d...	https://a2.muscache.com/ac/pictures/83538305/d...	https://a2.muscache.com/ac/pictures/83538305/d...	4016632	https://www.airbnb.com/users/show/4016632	Jean-Marc	2012-10-30	Seattle, Washington, United States	I am a carpenter at heart , I love music , I p...	within an hour	100%	100%	t	https://a1.muscache.com/ac/users/4016632/profi...	https://a1.muscache.com/ac/users/4016632/profi...	Queen Anne	5.0	5.0	['email', 'phone', 'facebook', 'google', 'link...	t	t	West Wheeler Street, Seattle, WA 98119, United...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.640161	-122.375856	t	Cabin	Private room	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet","Pets live on this proper...	NaN	$60.00	$360.00	NaN	$150.00	$25.00	1	$0.00	2	7	yesterday	t	22	42	42	100	2016-01-04	173	2013-01-03	2016-01-01	97.0	10.0	10.0	10.0	10.0	9.0	10.0	f	NaN	WASHINGTON	f	strict	t	t	5	4.73
8	4948745	https://www.airbnb.com/rooms/4948745	20160104002432	2016-01-04	Urban Charm \|\| Downtown \|\| Views	Nestled in the heart of the city, this space i...	Located in the heart of the city, this space i...	Nestled in the heart of the city, this space i...	none	Walking Score: 92 4 blocks from Kerry Park Fam...	NaN	Bus stop to downtown directly across the stree...	https://a0.muscache.com/ac/pictures/85453284/d...	https://a0.muscache.com/im/pictures/85453284/d...	https://a0.muscache.com/ac/pictures/85453284/d...	https://a0.muscache.com/ac/pictures/85453284/d...	2166277	https://www.airbnb.com/users/show/2166277	Aliza	2012-04-18	Seattle, Washington, United States	I'm a 35 year old professional from Seattle, W...	NaN	NaN	100%	f	https://a1.muscache.com/ac/users/2166277/profi...	https://a1.muscache.com/ac/users/2166277/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	Queen Anne Avenue North, Seattle, WA 98109, Un...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98109	Seattle	Seattle, WA	US	United States	47.632410	-122.357216	t	Apartment	Private room	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$90.00	$500.00	$1,700.00	NaN	NaN	1	$0.00	3	1125	5 months ago	t	6	36	66	341	2016-01-04	8	2015-06-22	2015-08-17	97.0	10.0	9.0	10.0	9.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	1.22
9	2493658	https://www.airbnb.com/rooms/2493658	20160104002432	2016-01-04	Airy + Bright Queen Anne Apartment	Beautiful apartment in an extremely safe, quie...	What's special about this place? A beautiful r...	Beautiful apartment in an extremely safe, quie...	none	Queen Anne is a wonderful, truly functional vi...	What's up with the free pillows? Our home was...	Convenient bus stops are just down the block, ...	https://a2.muscache.com/ac/pictures/33003258/f...	https://a2.muscache.com/im/pictures/33003258/f...	https://a2.muscache.com/ac/pictures/33003258/f...	https://a2.muscache.com/ac/pictures/33003258/f...	5177328	https://www.airbnb.com/users/show/5177328	Andrea	2013-02-21	Seattle, Washington, United States	Living east coast/left coast/overseas. Time i...	within an hour	98%	100%	t	https://a0.muscache.com/ac/users/5177328/profi...	https://a0.muscache.com/ac/users/5177328/profi...	Queen Anne	6.0	6.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	7th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.637492	-122.366889	t	Apartment	Entire home/apt	4	1.0	1.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Free...	NaN	$150.00	$1,000.00	$3,000.00	$100.00	$40.00	1	$0.00	2	365	today	t	6	19	49	324	2016-01-04	32	2014-04-27	2015-12-20	97.0	10.0	10.0	10.0	10.0	10.0	9.0	f	NaN	WASHINGTON	f	strict	t	t	6	1.55
10	175576	https://www.airbnb.com/rooms/175576	20160104002432	2016-01-04	Private Apartment - Queen Anne Hill	Queen Anne Hill is a charming neighborhood wit...	Be close to everything! Queen Anne Hill is a ...	Queen Anne Hill is a charming neighborhood wit...	none	Queen Anne Hill is a wonderful and historic ar...	We will provide you with a Parking Pass to han...	The bus stop is just two blocks from our house...	https://a0.muscache.com/ac/pictures/2788698/87...	https://a0.muscache.com/im/pictures/2788698/87...	https://a0.muscache.com/ac/pictures/2788698/87...	https://a0.muscache.com/ac/pictures/2788698/87...	239585	https://www.airbnb.com/users/show/239585	Ray & Eileen	2010-09-19	Seattle, Washington, United States	Eileen and Ray were born in Seattle just three...	within a few hours	100%	100%	t	https://a2.muscache.com/ac/users/239585/profil...	https://a2.muscache.com/ac/users/239585/profil...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	1st Ave W, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.635482	-122.358478	t	House	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$95.00	$595.00	NaN	NaN	$15.00	2	$15.00	3	7	a week ago	t	0	0	0	153	2016-01-04	181	2011-07-21	2015-11-25	97.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	t	f	1	3.33
11	4454295	https://www.airbnb.com/rooms/4454295	20160104002432	2016-01-04	Upper Queen Anne Craftsman House	Beautifully furnished, cozy 1 bedroom mid cent...	Beautiful home in an extremely walkable neighb...	Beautifully furnished, cozy 1 bedroom mid cent...	none	I am located in the Upper Queen Anne neighborh...	NaN	Yes, bus stops just 2-3 blocks away.	https://a0.muscache.com/ac/pictures/59566840/b...	https://a0.muscache.com/im/pictures/59566840/b...	https://a0.muscache.com/ac/pictures/59566840/b...	https://a0.muscache.com/ac/pictures/59566840/b...	4606439	https://www.airbnb.com/users/show/4606439	Nadia	2013-01-06	Seattle, Washington, United States	My name is Nadia, and I am a native of Seattle...	within a few hours	100%	100%	f	https://a1.muscache.com/ac/users/4606439/profi...	https://a1.muscache.com/ac/users/4606439/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	3rd Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.637214	-122.360046	t	House	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV","Wireless Internet",Kitchen,"Fr...	NaN	$99.00	$800.00	$2,000.00	$500.00	$150.00	1	$0.00	3	1125	a week ago	t	21	21	21	229	2016-01-04	8	2015-05-06	2015-12-16	97.0	10.0	10.0	9.0	10.0	10.0	9.0	f	NaN	WASHINGTON	f	strict	f	f	1	0.98
12	3883392	https://www.airbnb.com/rooms/3883392	20160104002432	2016-01-04	Open Plan 2bdr/1bath in Queen Anne	Spacious apt in popular Seattle neighborhood. ...	This apartment is in a quiet and friendly city...	Spacious apt in popular Seattle neighborhood. ...	none	This neighborhood is one of Seattle's popular ...	Seattle is a "green" town. Composting and re...	#1 bus is one block from the house to downtown...	https://a2.muscache.com/ac/pictures/48864586/9...	https://a2.muscache.com/im/pictures/48864586/9...	https://a2.muscache.com/ac/pictures/48864586/9...	https://a2.muscache.com/ac/pictures/48864586/9...	19932967	https://www.airbnb.com/users/show/19932967	Pat & Roberta	2014-08-13	Seattle, Washington, United States	We both grew up on Queen Anne Hill, then later...	within an hour	100%	100%	t	https://a1.muscache.com/ac/users/19932967/prof...	https://a1.muscache.com/ac/users/19932967/prof...	NaN	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'jum...	t	t	West Howe Street, Seattle, WA 98119, United St...	NaN	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.635546	-122.373171	t	Apartment	Entire home/apt	4	1.0	2.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$245.00	$1,575.00	$5,800.00	$300.00	$95.00	1	$0.00	3	14	2 weeks ago	t	30	60	90	362	2016-01-04	13	2014-11-09	2015-10-02	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	0.92
13	8889257	https://www.airbnb.com/rooms/8889257	20160104002432	2016-01-04	Elegance in Historic Queen Anne	Enjoy our amazing, updated & modern design cot...	Originally built in 1906, our house has a ligh...	Enjoy our amazing, updated & modern design cot...	none	Queen Anne hill became a popular spot for the ...	NaN	Street parking only. From West Prospect, park ...	https://a2.muscache.com/ac/pictures/69b4dfed-9...	https://a2.muscache.com/im/pictures/69b4dfed-9...	https://a2.muscache.com/ac/pictures/69b4dfed-9...	https://a2.muscache.com/ac/pictures/69b4dfed-9...	25899989	https://www.airbnb.com/users/show/25899989	Ellie	2015-01-10	Kirkland, Washington, United States	Hi, my name is Ellie. I’m a widow. My husban...	within an hour	100%	100%	f	https://a2.muscache.com/ac/pictures/5eee2738-1...	https://a2.muscache.com/ac/pictures/5eee2738-1...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	West Prospect Street, Seattle, WA 98119, Unite...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.629507	-122.367629	t	House	Entire home/apt	5	1.0	2.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$165.00	NaN	$5,000.00	$400.00	$85.00	4	$20.00	2	1125	today	t	13	40	63	337	2016-01-04	3	2015-12-16	2016-01-02	100.0	10.0	10.0	9.0	9.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	3.00
14	5680462	https://www.airbnb.com/rooms/5680462	20160104002432	2016-01-04	Stunning 6 bd in THE BEST Location!	Stunning Designsponge featured 6 bed, 3.75 bat...	Gorgeous, LIGHT FILLED, Newly Constructed Mode...	Stunning Designsponge featured 6 bed, 3.75 bat...	none	Queen Anne is THE BEST and most desirable neig...	The house is great for large groups or extende...	Hwy 99 and the 5 freeway are both easy to get ...	https://a2.muscache.com/ac/pictures/91278310/1...	https://a2.muscache.com/im/pictures/91278310/1...	https://a2.muscache.com/ac/pictures/91278310/1...	https://a2.muscache.com/ac/pictures/91278310/1...	22372266	https://www.airbnb.com/users/show/22372266	Sarah	2014-10-10	Seattle, Washington, United States	Originally from Southern California, my husban...	within an hour	100%	100%	f	https://a2.muscache.com/ac/users/22372266/prof...	https://a2.muscache.com/ac/users/22372266/prof...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	7th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.639203	-122.365863	t	House	Entire home/apt	16	3.5	6.0	15.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$461.00	NaN	NaN	$1,500.00	$300.00	8	$50.00	3	29	5 days ago	t	19	40	65	327	2016-01-04	18	2015-06-15	2015-11-15	98.0	9.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	strict	f	f	1	2.65
15	8988178	https://www.airbnb.com/rooms/8988178	20160104002432	2016-01-04	Lovely Queen Anne Cottage, 2 BR	This home is full of light, art and comfort. 5...	The Space This is a 1000 square foot, two bedr...	This home is full of light, art and comfort. 5...	none	Queen Anne is a charming and very safe neighbo...	NaN	You will be 2 blocks from the Metro stop. On ...	NaN	NaN	https://a2.muscache.com/ac/pictures/fa176cce-b...	NaN	2983711	https://www.airbnb.com/users/show/2983711	Paige	2012-07-18	Seattle, Washington, United States	I'm from Seattle. I am a designer, inventor a...	within a few hours	100%	100%	f	https://a0.muscache.com/ac/users/2983711/profi...	https://a0.muscache.com/ac/users/2983711/profi...	NaN	1.0	1.0	['email', 'reviews', 'kba']	t	f	12th Avenue West, Seattle, WA 98119, United St...	NaN	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.635650	-122.372893	f	House	Entire home/apt	5	1.0	2.0	2.0	Real Bed	{TV,"Cable TV",Internet,Kitchen,"Free Parking ...	NaN	$109.00	NaN	NaN	NaN	$89.00	1	$0.00	3	15	3 days ago	t	30	60	69	69	2016-01-04	1	2015-11-25	2015-11-25	80.0	8.0	10.0	8.0	8.0	8.0	8.0	f	NaN	WASHINGTON	f	strict	f	f	1	0.73
16	3245876	https://www.airbnb.com/rooms/3245876	20160104002432	2016-01-04	Park Life in Lower Queen Anne	Master bedroom suite with 1/4 bath & kitchenet...	**PLEASE MAKE SURE TO READ ALL INFO BEFORE BOO...	Master bedroom suite with 1/4 bath & kitchenet...	none	Lower Queen Anne is amazing - you can walk to ...	I have two cats, Tori Spelling and Denzel. The...	Taxi: Uber, Sidecar, and Lyft are all availabl...	https://a0.muscache.com/ac/pictures/57011178/e...	https://a0.muscache.com/im/pictures/57011178/e...	https://a0.muscache.com/ac/pictures/57011178/e...	https://a0.muscache.com/ac/pictures/57011178/e...	9465817	https://www.airbnb.com/users/show/9465817	Libby	2013-10-16	Seattle, Washington, United States	I'm a 37 year old recent law school graduate, ...	within an hour	100%	100%	f	https://a2.muscache.com/ac/users/9465817/profi...	https://a2.muscache.com/ac/users/9465817/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	West Mercer Place, Seattle, WA 98119, United S...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.626200	-122.366602	t	Apartment	Private room	2	1.0	1.0	1.0	Real Bed	{Internet,"Wireless Internet","Pets Allowed",B...	NaN	$66.00	NaN	NaN	$100.00	$35.00	1	$25.00	1	10	yesterday	t	29	59	89	364	2016-01-04	84	2014-06-30	2016-01-02	95.0	10.0	9.0	10.0	10.0	10.0	9.0	f	NaN	WASHINGTON	f	moderate	f	f	1	4.55
17	4933447	https://www.airbnb.com/rooms/4933447	20160104002432	2016-01-04	Private Garden Suite, Bay View	Beautiful private entrance garden suite overlo...	French Country style home built in 1939 with s...	Beautiful private entrance garden suite overlo...	none	We are located in Upper Queen Anne in walking ...	Electric hot water kettle provided for hot bev...	Our central location means quick access to all...	https://a1.muscache.com/ac/pictures/65170901/6...	https://a1.muscache.com/im/pictures/65170901/6...	https://a1.muscache.com/ac/pictures/65170901/6...	https://a1.muscache.com/ac/pictures/65170901/6...	25417834	https://www.airbnb.com/users/show/25417834	Markus And Melissa	2014-12-31	Seattle, Washington, United States	NaN	within an hour	100%	100%	t	https://a1.muscache.com/ac/users/25417834/prof...	https://a1.muscache.com/ac/users/25417834/prof...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	12th Avenue West, Seattle, WA 98119, United St...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.640646	-122.372406	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet","Free Parking on Premises...	NaN	$99.00	NaN	NaN	$100.00	$15.00	1	$0.00	2	14	2 weeks ago	t	29	52	82	171	2016-01-04	45	2015-03-16	2015-11-06	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	moderate	f	f	1	4.58
18	7735464	https://www.airbnb.com/rooms/7735464	20160104002432	2016-01-04	Queen Anne Getaway Near Seattle!	The second room in our spacious 2BR / 2 Bath a...	NaN	The second room in our spacious 2BR / 2 Bath a...	none	NaN	NaN	NaN	https://a2.muscache.com/ac/pictures/98338372/c...	https://a2.muscache.com/im/pictures/98338372/c...	https://a2.muscache.com/ac/pictures/98338372/c...	https://a2.muscache.com/ac/pictures/98338372/c...	6170760	https://www.airbnb.com/users/show/6170760	Sam	2013-04-30	Seattle, Washington, United States	Sam	NaN	NaN	NaN	f	https://a2.muscache.com/ac/users/6170760/profi...	https://a2.muscache.com/ac/users/6170760/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'jum...	t	t	11th Avenue West, Seattle, WA 98119, United St...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.639776	-122.372235	t	Apartment	Private room	2	2.0	1.0	1.0	Futon	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$200.00	NaN	NaN	NaN	NaN	1	$0.00	1	1125	5 months ago	t	0	0	0	125	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
19	6291829	https://www.airbnb.com/rooms/6291829	20160104002432	2016-01-04	Grand Craftsman Home on Queen Anne	This home built in 1909. It has 5 bedrooms a...	This home encompasses the character that is so...	This home built in 1909. It has 5 bedrooms a...	none	Upper Queen Anne is a charming neighborhood wi...	This is our family home that we choose to shar...	Easy bus access to all the sites: Lower Queen ...	NaN	NaN	https://a1.muscache.com/ac/pictures/78564472/f...	NaN	32713558	https://www.airbnb.com/users/show/32713558	Kary	2015-05-05	Seattle, Washington, United States	My husband and I have 3 young adult children a...	NaN	NaN	NaN	f	https://a2.muscache.com/ac/users/32713558/prof...	https://a2.muscache.com/ac/users/32713558/prof...	Queen Anne	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'kba']	t	t	1st Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.636025	-122.358694	t	House	Entire home/apt	10	3.5	5.0	5.0	Real Bed	{TV,"Cable TV","Wireless Internet",Kitchen,"Fr...	NaN	$700.00	$4,100.00	NaN	$500.00	$250.00	1	$0.00	3	30	2 months ago	t	24	54	84	359	2016-01-04	5	2015-07-07	2015-08-10	85.0	10.0	9.0	9.0	9.0	8.0	8.0	f	NaN	WASHINGTON	f	flexible	f	f	1	0.82
20	9218403	https://www.airbnb.com/rooms/9218403	20160104002432	2016-01-04	Queen Anne View One Bedroom	This clean and comfortable one bedroom sits ri...	Kitchen has hot water tap and sodastream Excel...	This clean and comfortable one bedroom sits ri...	none	Lower Queen Anne is near the Seattle Center (s...	NaN	NaN	https://a2.muscache.com/ac/pictures/6374cb3b-a...	https://a2.muscache.com/im/pictures/6374cb3b-a...	https://a2.muscache.com/ac/pictures/6374cb3b-a...	https://a2.muscache.com/ac/pictures/6374cb3b-a...	14100483	https://www.airbnb.com/users/show/14100483	Annie	2014-04-09	Quilcene, Washington, United States	NaN	within a few hours	100%	100%	f	https://a0.muscache.com/ac/users/14100483/prof...	https://a0.muscache.com/ac/users/14100483/prof...	NaN	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	West Olympic Place, Seattle, WA 98119, United ...	NaN	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.627940	-122.364959	f	Condominium	Entire home/apt	1	1.0	1.0	1.0	Real Bed	{Internet,"Wireless Internet",Kitchen,"Free Pa...	NaN	$110.00	$750.00	$2,500.00	NaN	NaN	1	$0.00	1	1125	4 weeks ago	t	29	55	85	360	2016-01-04	1	2016-01-03	2016-01-03	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	flexible	f	f	1	1.00
21	4125779	https://www.airbnb.com/rooms/4125779	20160104002432	2016-01-04	Cozy Queen Anne Finished Basement	Relax in your own private finished basement sp...	Updated daylight basement space with queen and...	Relax in your own private finished basement sp...	none	Just a few minutes walk to many great restaura...	Free parking. Queen Anne Farmers Market is on...	Metro Transit Bus #13 takes you to downtown Se...	https://a1.muscache.com/ac/pictures/52657137/d...	https://a1.muscache.com/im/pictures/52657137/d...	https://a1.muscache.com/ac/pictures/52657137/d...	https://a1.muscache.com/ac/pictures/52657137/d...	21401856	https://www.airbnb.com/users/show/21401856	Nick	2014-09-16	Seattle, Washington, United States	I am a father, a devoted husband, a passionate...	within an hour	100%	100%	f	https://a1.muscache.com/ac/users/21401856/prof...	https://a1.muscache.com/ac/users/21401856/prof...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews']	t	f	2nd Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.636374	-122.361033	t	House	Private room	3	1.5	1.0	2.0	Real Bed	{"Cable TV",Internet,"Wireless Internet","Free...	NaN	$99.00	$568.00	$2,029.00	NaN	$15.00	1	$10.00	1	1125	2 months ago	t	30	60	90	365	2016-01-04	11	2014-09-27	2015-10-18	84.0	9.0	9.0	9.0	9.0	10.0	8.0	f	NaN	WASHINGTON	f	moderate	f	f	1	0.71
22	8942678	https://www.airbnb.com/rooms/8942678	20160104002432	2016-01-04	Lovely Queen Anne home	Welcome to Seattle! Enjoy your stay in a turn...	Centrally located spacious home in the heart o...	Welcome to Seattle! Enjoy your stay in a turn...	none	Queen Anne is a wonderful mix of beautiful tre...	NaN	The bus stop is 3 blocks away. You are an easy...	NaN	NaN	https://a2.muscache.com/ac/pictures/c7e454ce-7...	NaN	46675077	https://www.airbnb.com/users/show/46675077	Susanna	2015-10-16	Seattle, Washington, United States	NaN	within a day	100%	100%	f	https://a2.muscache.com/ac/pictures/facd36b6-c...	https://a2.muscache.com/ac/pictures/facd36b6-c...	Queen Anne	1.0	1.0	['phone', 'reviews']	t	f	1st Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.635632	-122.358881	t	House	Entire home/apt	8	2.0	4.0	4.0	Real Bed	{TV,"Wireless Internet",Kitchen,"Free Parking ...	NaN	$450.00	$3,000.00	NaN	NaN	NaN	1	$0.00	4	1125	2 months ago	t	0	0	0	53	2016-01-04	1	2015-12-01	2015-12-01	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	flexible	f	f	1	0.86
23	10106055	https://www.airbnb.com/rooms/10106055	20160104002432	2016-01-04	Cozy Lower Level, Upper Queen Anne	Greetings! Our home is a beautiful, 1920's 4 ...	The space we are renting is the entire lower l...	Greetings! Our home is a beautiful, 1920's 4 ...	none	Queen Anne is a lovely and venerable Seattle n...	NaN	Our home is conveniently located within walkin...	https://a2.muscache.com/ac/pictures/3f11eb1a-3...	https://a2.muscache.com/im/pictures/3f11eb1a-3...	https://a2.muscache.com/ac/pictures/3f11eb1a-3...	https://a2.muscache.com/ac/pictures/3f11eb1a-3...	51860756	https://www.airbnb.com/users/show/51860756	Maggie & Alex	2015-12-20	Seattle, Washington, United States	Hello! We're Maggie & Alex, and we are very ex...	NaN	NaN	NaN	f	https://a2.muscache.com/ac/pictures/11543d26-5...	https://a2.muscache.com/ac/pictures/11543d26-5...	Queen Anne	1.0	1.0	['phone']	t	f	West Galer Street, Seattle, WA 98119, United S...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.633394	-122.371920	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{Internet,"Wireless Internet","Air Conditionin...	NaN	$75.00	$350.00	NaN	NaN	NaN	1	$0.00	1	1125	today	t	30	60	90	365	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
24	6362362	https://www.airbnb.com/rooms/6362362	20160104002432	2016-01-04	Charming home on Queen Anne	Enjoy Seattle from the ideally located Queen A...	Step into the main living space with sitting a...	Enjoy Seattle from the ideally located Queen A...	none	NaN	There is plenty of street parking and one desi...	10th Avenue West is on the bus line taking you...	NaN	NaN	https://a1.muscache.com/ac/pictures/79617550/d...	NaN	33147763	https://www.airbnb.com/users/show/33147763	Tracy	2015-05-11	Seattle, Washington, United States	NaN	NaN	NaN	NaN	f	https://a1.muscache.com/ac/users/33147763/prof...	https://a1.muscache.com/ac/users/33147763/prof...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews']	t	f	10th Avenue West, Seattle, WA 98119, United St...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.638517	-122.369581	t	House	Entire home/apt	5	2.5	3.0	3.0	Real Bed	{TV,"Cable TV","Wireless Internet",Kitchen,"Fr...	NaN	$600.00	NaN	NaN	$500.00	$150.00	1	$0.00	3	1125	3 months ago	t	0	0	0	212	2016-01-04	1	2015-07-20	2015-07-20	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	0.18
25	3544550	https://www.airbnb.com/rooms/3544550	20160104002432	2016-01-04	VIEW-Monthly Rental Available	Our home is very light and full of character a...	Our home is a brick tudor/cottage built in 193...	Our home is very light and full of character a...	none	Upper Queen Anne is a charming neighborhood fu...	Our house is located just 5 short blocks to To...	A bus stop is just 2 blocks away. Easy bus a...	NaN	NaN	https://a1.muscache.com/ac/pictures/44791979/6...	NaN	16708587	https://www.airbnb.com/users/show/16708587	Jill	2014-06-12	Seattle, Washington, United States	i love living in Seattle. i grew up in the mi...	within a few hours	67%	100%	f	https://a1.muscache.com/ac/users/16708587/prof...	https://a1.muscache.com/ac/users/16708587/prof...	Queen Anne	2.0	2.0	['email', 'phone', 'google', 'reviews', 'jumio']	t	t	7th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.631397	-122.367767	t	House	Entire home/apt	8	2.5	3.0	5.0	Real Bed	{TV,"Cable TV","Wireless Internet","Air Condit...	NaN	$450.00	NaN	NaN	$500.00	$200.00	6	$50.00	4	1125	today	t	0	3	33	293	2016-01-04	8	2015-07-04	2015-09-02	100.0	10.0	10.0	9.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	2	1.30
26	9025039	https://www.airbnb.com/rooms/9025039	20160104002432	2016-01-04	Cute Bungalow-Close to Everything!	Our cozy little bungalow is the perfect place ...	One bedroom has a queen sized bed, and the oth...	Our cozy little bungalow is the perfect place ...	none	The Queen Anne neighborhood is one of the most...	The Queen Anne neighborhood is one of the most...	There are several bus routes a few short steps...	NaN	NaN	https://a2.muscache.com/ac/pictures/21a1c1e1-f...	NaN	68155	https://www.airbnb.com/users/show/68155	Lori	2010-01-06	Seattle, Washington, United States	Mom to two young boys, writer, real estate bro...	within a few hours	100%	100%	f	https://a2.muscache.com/ac/users/68155/profile...	https://a2.muscache.com/ac/users/68155/profile...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'jum...	t	t	West McGraw Street, Seattle, WA 98119, United ...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.638752	-122.367973	t	House	Entire home/apt	5	1.0	2.0	3.0	Real Bed	{"Cable TV","Wireless Internet",Kitchen,"Free ...	NaN	$150.00	NaN	NaN	$250.00	$35.00	1	$0.00	1	1125	3 days ago	t	0	0	0	49	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
27	3200646	https://www.airbnb.com/rooms/3200646	20160104002432	2016-01-04	Micro Gypsy Wagon on Queen Anne	Micro camper with queen size bed and seating f...	The Spruce Kaboose is a hand built one of a ki...	Micro camper with queen size bed and seating f...	none	Interbay is right between downtown Seattle and...	There are THREE rentals in our yard . If your ...	We are on the D bus line. If you are busing f...	https://a0.muscache.com/ac/pictures/67216372/d...	https://a0.muscache.com/im/pictures/67216372/d...	https://a0.muscache.com/ac/pictures/67216372/d...	https://a0.muscache.com/ac/pictures/67216372/d...	4016632	https://www.airbnb.com/users/show/4016632	Jean-Marc	2012-10-30	Seattle, Washington, United States	I am a carpenter at heart , I love music , I p...	within an hour	100%	100%	t	https://a1.muscache.com/ac/users/4016632/profi...	https://a1.muscache.com/ac/users/4016632/profi...	Queen Anne	5.0	5.0	['email', 'phone', 'facebook', 'google', 'link...	t	t	West Wheeler Street, Seattle, WA 98119, United...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.639266	-122.374726	t	Camper/RV	Private room	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet","Pets live on this proper...	NaN	$45.00	$360.00	NaN	$150.00	$25.00	1	$0.00	2	7	yesterday	t	22	49	49	107	2016-01-04	80	2014-07-06	2016-01-02	95.0	10.0	10.0	10.0	10.0	9.0	9.0	f	NaN	WASHINGTON	f	strict	t	t	5	4.38
28	8859380	https://www.airbnb.com/rooms/8859380	20160104002432	2016-01-04	STUNNING VIEW of Puget Sound	This three bedroom flat is your gorgeous retre...	You won't want to leave your home away from ho...	This three bedroom flat is your gorgeous retre...	none	Located in the beautiful neighborhood of Queen...	NaN	You have on-site parking if you have a car. If...	NaN	NaN	https://a2.muscache.com/ac/pictures/ed5b5e7c-7...	NaN	3792761	https://www.airbnb.com/users/show/3792761	Kimberly	2012-10-07	Seattle, Washington, United States	I am from Seattle WA, and I love to travel! \r...	within an hour	100%	100%	f	https://a2.muscache.com/ac/pictures/15d8ced5-c...	https://a2.muscache.com/ac/pictures/15d8ced5-c...	Queen Anne	5.0	5.0	['email', 'phone', 'reviews', 'jumio', 'kba']	t	t	9th Avenue West, Seattle, WA 98119, United States	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.629907	-122.368948	t	Apartment	Entire home/apt	6	2.0	3.0	3.0	Real Bed	{TV,"Cable TV","Wireless Internet",Kitchen,"Fr...	NaN	$300.00	NaN	NaN	$500.00	$125.00	1	$0.00	2	1125	4 days ago	t	24	54	84	356	2016-01-04	6	2015-10-24	2016-01-02	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	moderate	f	f	1	2.47
29	4520099	https://www.airbnb.com/rooms/4520099	20160104002432	2016-01-04	Open Airy Queen Anne Condo	Designer home situated on Queen Anne Hill over...	During the summer, there was construction on t...	Designer home situated on Queen Anne Hill over...	none	This is a really quiet neighborhood with plent...	My neighbors are really quiet and the condo do...	There is a very convenient bus line a block aw...	https://a0.muscache.com/ac/pictures/60875300/3...	https://a0.muscache.com/im/pictures/60875300/3...	https://a0.muscache.com/ac/pictures/60875300/3...	https://a0.muscache.com/ac/pictures/60875300/3...	6184895	https://www.airbnb.com/users/show/6184895	Lana	2013-05-01	Seattle, Washington, United States	NaN	within an hour	71%	100%	f	https://a1.muscache.com/ac/users/6184895/profi...	https://a1.muscache.com/ac/users/6184895/profi...	Queen Anne	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	14th Avenue West, Seattle, WA 98119, United St...	Queen Anne	West Queen Anne	Queen Anne	Seattle	WA	98119	Seattle	Seattle, WA	US	United States	47.639816	-122.374338	t	Apartment	Entire home/apt	3	1.0	1.0	2.0	Real Bed	{TV,"Cable TV","Wireless Internet","Wheelchair...	NaN	$80.00	$500.00	NaN	NaN	$65.00	3	$50.00	2	1125	5 days ago	t	0	1	30	305	2016-01-04	4	2015-01-04	2015-07-25	85.0	8.0	9.0	7.0	10.0	9.0	9.0	f	NaN	WASHINGTON	f	strict	f	f	1	0.33
...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...	...
3788	7745196	https://www.airbnb.com/rooms/7745196	20160104002432	2016-01-04	Cozy Modern Apartment in Fremont	Our apartment is bright and airy and a modern ...	Our apartment is brand new construction with t...	Our apartment is bright and airy and a modern ...	none	The Fremont neighborhood of Seattle is known a...	We strive to stay competitive on rates while o...	It's easy to get around Seattle from our neigh...	https://a2.muscache.com/ac/pictures/102889373/...	https://a2.muscache.com/im/pictures/102889373/...	https://a2.muscache.com/ac/pictures/102889373/...	https://a2.muscache.com/ac/pictures/102889373/...	398005	https://www.airbnb.com/users/show/398005	Trevor	2011-02-18	Seattle, Washington, United States	I'm from Seattle, WA, where I live with the lo...	within an hour	100%	100%	f	https://a0.muscache.com/ac/users/398005/profil...	https://a0.muscache.com/ac/users/398005/profil...	Fremont	1.0	1.0	['email', 'phone', 'google', 'reviews', 'kba']	t	t	Woodland Park Avenue North, Seattle, WA 98103,...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.656739	-122.344865	t	Apartment	Entire home/apt	4	1.0	1.0	2.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,Heati...	NaN	$115.00	$850.00	$3,240.00	$199.00	$60.00	2	$12.00	1	1125	2 weeks ago	t	20	46	76	347	2016-01-04	14	2015-09-03	2015-12-20	99.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	3.39
3789	4645405	https://www.airbnb.com/rooms/4645405	20160104002432	2016-01-04	Private light, minimalist room	The extremely comfortable sleep number Califor...	Vintage, modern 1910 craftsman with dark expos...	The extremely comfortable sleep number Califor...	none	I love that I can walk 15 minutes into Fremont...	Check in: 6pm Check out: 10am There is a lock...	Walk Score :Very Walkable Transit Score: Good ...	https://a2.muscache.com/ac/pictures/109434352/...	https://a2.muscache.com/im/pictures/109434352/...	https://a2.muscache.com/ac/pictures/109434352/...	https://a2.muscache.com/ac/pictures/109434352/...	13771267	https://www.airbnb.com/users/show/13771267	Paige	2014-04-01	Seattle, Washington, United States	I am a freelance photographer born and raised ...	within a few hours	100%	100%	f	https://a1.muscache.com/ac/users/13771267/prof...	https://a1.muscache.com/ac/users/13771267/prof...	Fremont	2.0	2.0	['email', 'phone', 'reviews', 'kba']	t	t	North 46th Street, Seattle, WA 98103, United S...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.661171	-122.349923	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,Heati...	NaN	$60.00	$500.00	$1,500.00	NaN	$10.00	2	$25.00	1	14	today	t	28	54	84	359	2016-01-04	23	2015-02-17	2015-11-28	90.0	9.0	9.0	9.0	10.0	9.0	9.0	f	NaN	WASHINGTON	f	flexible	f	f	2	2.14
3790	2755730	https://www.airbnb.com/rooms/2755730	20160104002432	2016-01-04	Your own 2 Bedroom home in Fremont	Private 2 bedroom retreat in the heart of Frem...	The house was built in 1906 by the Seattle Lum...	Private 2 bedroom retreat in the heart of Frem...	none	Very walkable, with lots of bike lanes and qui...	NaN	Metro transit lines are one block away with di...	https://a1.muscache.com/ac/pictures/40919375/2...	https://a1.muscache.com/im/pictures/40919375/2...	https://a1.muscache.com/ac/pictures/40919375/2...	https://a1.muscache.com/ac/pictures/40919375/2...	3752499	https://www.airbnb.com/users/show/3752499	Donna	2012-10-04	Seattle, Washington, United States	I am so proud to have converted the first floo...	within an hour	100%	100%	t	https://a2.muscache.com/ac/users/3752499/profi...	https://a2.muscache.com/ac/users/3752499/profi...	Fremont	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	North 35th Street, Seattle, WA 98103, United S...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.649271	-122.347817	t	Apartment	Entire home/apt	6	1.0	2.0	3.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Pets...	NaN	$175.00	NaN	NaN	$250.00	$50.00	4	$30.00	2	29	today	t	18	48	78	335	2016-01-04	75	2014-05-18	2015-12-14	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	strict	f	f	1	3.77
3791	7949448	https://www.airbnb.com/rooms/7949448	20160104002432	2016-01-04	Private Suite in Fremont-Ballard	This is a private suite with bedroom and bathr...	This is a ground floor bedroom in our townhous...	This is a private suite with bedroom and bathr...	none	Our house is centrally located between Ballard...	Parking There is adequate free parking on the ...	BUS LINES The house is close to bus lines tha...	https://a1.muscache.com/ac/pictures/101354275/...	https://a1.muscache.com/im/pictures/101354275/...	https://a1.muscache.com/ac/pictures/101354275/...	https://a1.muscache.com/ac/pictures/101354275/...	26392625	https://www.airbnb.com/users/show/26392625	Jason	2015-01-20	Seattle, Washington, United States	My name is Jason and my wife is Keri. We have...	within a few hours	100%	100%	f	https://a0.muscache.com/ac/users/26392625/prof...	https://a0.muscache.com/ac/users/26392625/prof...	Fremont	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'kba']	t	t	6th Avenue Northwest, Seattle, WA 98107, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.659149	-122.363466	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","F...	NaN	$85.00	$600.00	$2,250.00	$100.00	$40.00	1	$0.00	2	30	4 days ago	t	29	59	89	178	2016-01-04	11	2015-08-25	2015-11-28	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	2.48
3792	9288840	https://www.airbnb.com/rooms/9288840	20160104002432	2016-01-04	City Haven	Vacationing in Seattle? Traveling for business...	NaN	Vacationing in Seattle? Traveling for business...	none	NaN	NaN	NaN	https://a2.muscache.com/ac/pictures/40835954-c...	https://a2.muscache.com/im/pictures/40835954-c...	https://a2.muscache.com/ac/pictures/40835954-c...	https://a2.muscache.com/ac/pictures/40835954-c...	15784748	https://www.airbnb.com/users/show/15784748	Teresa	2014-05-20	Seattle, Washington, United States	NaN	within an hour	100%	NaN	f	https://a2.muscache.com/ac/pictures/34a8914a-2...	https://a2.muscache.com/ac/pictures/34a8914a-2...	Fremont	1.0	1.0	['email', 'phone', 'kba']	t	f	North 46th Street, Seattle, WA 98103, United S...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.663040	-122.348499	t	Apartment	Entire home/apt	4	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$109.00	NaN	NaN	$200.00	$45.00	1	$0.00	2	1125	5 days ago	t	0	0	0	34	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
3793	3312406	https://www.airbnb.com/rooms/3312406	20160104002432	2016-01-04	Seattle Urban-Chic Studio Cottage	Come stay at this 2014 Northwest Green Home To...	Private, just-built, high-end studio loft in a...	Come stay at this 2014 Northwest Green Home To...	none	Renowned restaurants, coffeshops and bars, the...	We occasionally have friends over for evening ...	Super convenient to EVERYTHING and all the bes...	NaN	NaN	https://a1.muscache.com/ac/pictures/54326594/8...	NaN	16727906	https://www.airbnb.com/users/show/16727906	Tory	2014-06-13	Seattle, Washington, United States	My husband, Adam, and I, live in the main hous...	within an hour	100%	100%	t	https://a0.muscache.com/ac/users/16727906/prof...	https://a0.muscache.com/ac/users/16727906/prof...	Fremont	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	Baker Avenue Northwest, Seattle, WA 98107, Uni...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.660056	-122.357683	t	House	Entire home/apt	4	1.0	0.0	2.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$109.00	$725.00	$2,895.00	$200.00	$55.00	4	$30.00	2	180	today	t	17	44	66	341	2016-01-04	78	2014-07-07	2015-12-30	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	strict	f	f	1	4.28
3794	6621924	https://www.airbnb.com/rooms/6621924	20160104002432	2016-01-04	Hazel Heights Hideout	An one-bedroom apartment in the top level of m...	Enter via the big back deck which has views of...	An one-bedroom apartment in the top level of m...	none	Fremont - The Center Of The Universe. This ne...	My neighborhood is a residential neighborhood,...	Walking distance to Fremont, which has tons of...	https://a1.muscache.com/ac/pictures/85686578/1...	https://a1.muscache.com/im/pictures/85686578/1...	https://a1.muscache.com/ac/pictures/85686578/1...	https://a1.muscache.com/ac/pictures/85686578/1...	30049045	https://www.airbnb.com/users/show/30049045	Tim And Amanda	2015-03-26	Seattle, Washington, United States	Passionate travelers and hosts! We hope you do...	within a few hours	80%	100%	f	https://a2.muscache.com/ac/users/30049045/prof...	https://a2.muscache.com/ac/users/30049045/prof...	Fremont	1.0	1.0	['email', 'phone', 'reviews', 'jumio']	t	t	Northwest Bowdoin Place, Seattle, WA 98107, Un...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.654199	-122.359987	t	Apartment	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{"Wireless Internet",Kitchen,Heating,"Smoke De...	NaN	$107.00	$1,000.00	$3,633.00	NaN	$40.00	2	$30.00	2	1125	2 months ago	t	30	60	89	89	2016-01-04	21	2015-06-16	2015-12-15	90.0	9.0	9.0	10.0	10.0	9.0	8.0	f	NaN	WASHINGTON	f	flexible	f	f	1	3.10
3795	5673552	https://www.airbnb.com/rooms/5673552	20160104002432	2016-01-04	Beautiful loft in downtown Fremont	Our cool loft apartment offers a convenient lo...	This historic building houses a converted stor...	Our cool loft apartment offers a convenient lo...	none	Fremont is a unique, young neighborhood filled...	Since the apartment is right on the streets of...	Easily accessible from the SeaTac Airport by b...	https://a2.muscache.com/ac/pictures/73308107/f...	https://a2.muscache.com/im/pictures/73308107/f...	https://a2.muscache.com/ac/pictures/73308107/f...	https://a2.muscache.com/ac/pictures/73308107/f...	28007250	https://www.airbnb.com/users/show/28007250	Brittney	2015-02-19	Seattle, Washington, United States	Working for Brooks Sports, love living in Seat...	within an hour	100%	100%	t	https://a1.muscache.com/ac/users/28007250/prof...	https://a1.muscache.com/ac/users/28007250/prof...	NaN	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'jum...	t	t	Woodland Park Ave N, Seattle, WA 98103, United...	NaN	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.650124	-122.343283	f	Loft	Entire home/apt	4	1.0	0.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$200.00	NaN	NaN	NaN	$40.00	1	$0.00	2	1125	3 months ago	t	2	2	2	265	2016-01-04	10	2015-04-26	2015-10-24	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	flexible	f	f	1	1.18
3796	609701	https://www.airbnb.com/rooms/609701	20160104002432	2016-01-04	Charming Fremont Garden Cottage	Enjoy the excitement of Seattle and city life ...	Charming and pristine pied-a-terre in the mids...	Enjoy the excitement of Seattle and city life ...	none	FREMONT is such a fun neighborhood with lot's ...	Street parking is usually plentiful so help yo...	NaN	https://a2.muscache.com/ac/pictures/8157091/5a...	https://a2.muscache.com/im/pictures/8157091/5a...	https://a2.muscache.com/ac/pictures/8157091/5a...	https://a2.muscache.com/ac/pictures/8157091/5a...	3023407	https://www.airbnb.com/users/show/3023407	Nan	2012-07-23	Seattle, Washington, United States	I'm a native Northwesterner and love to travel...	within an hour	100%	100%	t	https://a0.muscache.com/ac/users/3023407/profi...	https://a0.muscache.com/ac/users/3023407/profi...	Fremont	1.0	1.0	['email', 'phone', 'reviews', 'jumio']	t	t	NW 40th St, Seattle, WA 98107, United States	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.656508	-122.360571	t	Cabin	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV","Wireless Internet",Kitchen,"Fr...	NaN	$85.00	NaN	NaN	NaN	$20.00	1	$0.00	2	30	yesterday	t	25	48	75	307	2016-01-04	233	2012-07-29	2015-12-31	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	t	moderate	f	f	1	5.57
3797	10118341	https://www.airbnb.com/rooms/10118341	20160104002432	2016-01-04	Fremont Lighthouse Mother-in-Law	A clean and simple mother-in-law across the st...	A clean and simple mother-in-law basement stud...	A clean and simple mother-in-law across the st...	none	Located at the top of Fremont neighborhood/up ...	NaN	NaN	https://a2.muscache.com/ac/pictures/8cf79670-c...	https://a2.muscache.com/im/pictures/8cf79670-c...	https://a2.muscache.com/ac/pictures/8cf79670-c...	https://a2.muscache.com/ac/pictures/8cf79670-c...	1237248	https://www.airbnb.com/users/show/1237248	Elise	2011-10-02	Seattle, Washington, United States	Technology Marketing professional, likes outdo...	within an hour	100%	100%	f	https://a0.muscache.com/ac/users/1237248/profi...	https://a0.muscache.com/ac/users/1237248/profi...	Fremont	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'kba']	t	t	Phinney Avenue North, Seattle, WA 98103, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.658976	-122.354915	t	House	Entire home/apt	2	1.0	0.0	1.0	Futon	{"Wireless Internet",Kitchen,Heating,Washer,Dr...	NaN	$70.00	NaN	NaN	$200.00	NaN	2	$20.00	3	1125	yesterday	t	2	2	2	2	2016-01-04	1	2016-01-02	2016-01-02	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	1.00
3798	2614387	https://www.airbnb.com/rooms/2614387	20160104002432	2016-01-04	Everything Seattle in 0-3 miles, A	Spacious 1 bedroom: private 3/4 bathroom, Quee...	New, modern, clean, quiet and no clutter, yet ...	Spacious 1 bedroom: private 3/4 bathroom, Quee...	none	I love everything about my neighborhood, Seatt...	A few blocks from the house is Manolin Seafood...	Free on-street parking. Easy public transit. B...	https://a0.muscache.com/ac/pictures/63200945/a...	https://a0.muscache.com/im/pictures/63200945/a...	https://a0.muscache.com/ac/pictures/63200945/a...	https://a0.muscache.com/ac/pictures/63200945/a...	1123549	https://www.airbnb.com/users/show/1123549	Sandy	2011-09-07	Seattle, Washington, United States	Hello,\r\nI like the airbnb concept because I ...	within an hour	100%	100%	f	https://a0.muscache.com/ac/users/1123549/profi...	https://a0.muscache.com/ac/users/1123549/profi...	Fremont	2.0	2.0	['email', 'phone', 'reviews', 'kba']	t	t	Midvale Avenue North, Seattle, WA 98103, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.655381	-122.343205	t	House	Private room	2	1.0	1.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Free...	NaN	$77.00	$499.00	NaN	NaN	$15.00	2	$15.00	2	14	a week ago	t	19	42	72	338	2016-01-04	128	2014-03-31	2015-12-31	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	2	5.95
3799	7735100	https://www.airbnb.com/rooms/7735100	20160104002432	2016-01-04	Master bedroom in Fremont	The townhouse is conveniently blocks away from...	NaN	The townhouse is conveniently blocks away from...	none	NaN	NaN	NaN	NaN	NaN	https://a1.muscache.com/ac/pictures/98338478/f...	NaN	7227474	https://www.airbnb.com/users/show/7227474	Roger	2013-07-01	Seattle, Washington, United States	Hi! I've spent my whole life on the west coast...	a few days or more	25%	100%	f	https://a0.muscache.com/ac/users/7227474/profi...	https://a0.muscache.com/ac/users/7227474/profi...	Fremont	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	Dayton Avenue North, Seattle, WA 98103, United...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.652902	-122.352110	t	Townhouse	Private room	2	1.0	1.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Free...	NaN	$65.00	$375.00	$1,400.00	$150.00	$25.00	1	$0.00	2	1125	2 weeks ago	t	6	6	6	269	2016-01-04	5	2015-08-16	2015-12-25	95.0	10.0	9.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	1.06
3800	5482204	https://www.airbnb.com/rooms/5482204	20160104002432	2016-01-04	Six room suite	Seattle's most elegant and romantic lit...	Each suite is 900 square feet of luxury and el...	Seattle's most elegant and romantic lit...	none	Chelsea Station Inn is walking distance to the...	Each suite's kitchen is coffee ready with Nesp...	Super easy by bus or driving !	https://a1.muscache.com/ac/pictures/69724382/f...	https://a1.muscache.com/im/pictures/69724382/f...	https://a1.muscache.com/ac/pictures/69724382/f...	https://a1.muscache.com/ac/pictures/69724382/f...	28432113	https://www.airbnb.com/users/show/28432113	Chelsea Station Inn	2015-02-27	Seattle, Washington, United States	Seattle's most elegant and romantic little Inn...	NaN	NaN	NaN	f	https://a2.muscache.com/ac/users/28432113/prof...	https://a2.muscache.com/ac/users/28432113/prof...	Fremont	1.0	1.0	['email', 'phone']	t	f	Linden Avenue North, Seattle, WA 98103, United...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.663613	-122.349519	t	Bed & Breakfast	Private room	2	1.5	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$185.00	NaN	NaN	NaN	NaN	1	$0.00	1	1125	10 months ago	t	0	0	0	275	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	strict	f	f	1	NaN
3801	4524575	https://www.airbnb.com/rooms/4524575	20160104002432	2016-01-04	Comfortable Fremont Apartment	This lovely apartment is located on the lower ...	Our recently renovated apartment is perfect fo...	This lovely apartment is located on the lower ...	none	Fremont is centrally located within the city a...	NaN	4 blocks to the #5 bus stop, providing a >20 m...	https://a1.muscache.com/ac/pictures/56811707/6...	https://a1.muscache.com/im/pictures/56811707/6...	https://a1.muscache.com/ac/pictures/56811707/6...	https://a1.muscache.com/ac/pictures/56811707/6...	20853099	https://www.airbnb.com/users/show/20853099	Flora	2014-09-02	Seattle, Washington, United States	I love family, community, people, culture, art...	within a few hours	100%	100%	t	https://a1.muscache.com/ac/users/20853099/prof...	https://a1.muscache.com/ac/users/20853099/prof...	Fremont	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'kba']	t	t	1st Avenue Northwest, Seattle, WA 98107, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.657078	-122.358795	t	Apartment	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$108.00	$700.00	$2,500.00	$200.00	$45.00	2	$10.00	4	1125	a week ago	t	30	56	85	85	2016-01-04	28	2014-11-21	2015-12-10	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	2.05
3802	8562314	https://www.airbnb.com/rooms/8562314	20160104002432	2016-01-04	Cozy Craftsman in Heart of Fremont	Our rare for its location, 2 bedroom and 1 bat...	In a land ruled by condos, it's hard to find a...	Our rare for its location, 2 bedroom and 1 bat...	none	I loved living here before we had 3 kids. The ...	Please no parties or large groups at our home....	There is a bus stop on the corner of the stree...	https://a0.muscache.com/ac/pictures/108784666/...	https://a0.muscache.com/im/pictures/108784666/...	https://a0.muscache.com/ac/pictures/108784666/...	https://a0.muscache.com/ac/pictures/108784666/...	18774473	https://www.airbnb.com/users/show/18774473	Victoria	2014-07-23	US	NaN	NaN	NaN	NaN	f	https://a2.muscache.com/ac/pictures/9de2d88b-0...	https://a2.muscache.com/ac/pictures/9de2d88b-0...	NaN	1.0	1.0	['email', 'phone']	t	f	North 35th Street, Seattle, WA 98103, United S...	NaN	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.650765	-122.347787	f	House	Entire home/apt	4	1.0	2.0	2.0	Real Bed	{TV,"Wireless Internet",Kitchen,"Pets Allowed"...	NaN	$200.00	$1,300.00	$5,400.00	NaN	NaN	1	$0.00	2	1125	3 months ago	t	0	0	0	247	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN
3803	9698202	https://www.airbnb.com/rooms/9698202	20160104002432	2016-01-04	Clean City House, Lots of Beds	Get anywhere in Seattle quickly from this grea...	The space is well suited for large groups and ...	Get anywhere in Seattle quickly from this grea...	none	This house is central to any neighborhood you'...	NaN	Bus lines galore! If you want to use public tr...	https://a2.muscache.com/ac/pictures/60f3d68d-f...	https://a2.muscache.com/im/pictures/60f3d68d-f...	https://a2.muscache.com/ac/pictures/60f3d68d-f...	https://a2.muscache.com/ac/pictures/60f3d68d-f...	5325329	https://www.airbnb.com/users/show/5325329	Blair	2013-03-04	Seattle, Washington, United States	My name is Blair and I'm glad you are interest...	within a few hours	97%	100%	f	https://a0.muscache.com/ac/users/5325329/profi...	https://a0.muscache.com/ac/users/5325329/profi...	Queen Anne	9.0	9.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	Linden Avenue North, Seattle, WA 98103, United...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.661131	-122.349238	t	House	Entire home/apt	16	3.5	4.0	10.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,"Free...	NaN	$250.00	NaN	NaN	$250.00	$100.00	12	$25.00	1	1125	today	t	25	51	72	328	2016-01-04	4	2015-12-14	2016-01-01	95.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	8	4.00
3804	7178490	https://www.airbnb.com/rooms/7178490	20160104002432	2016-01-04	Cedar House Studio Suite in Fremont	Comfortable and clean, this lower level suite ...	A lush, private garden path leads to the entra...	Comfortable and clean, this lower level suite ...	none	Upper Fremont is a vibrant neighborhood that o...	There is a second staircase that leads to our ...	This apartment is centrally located amongst th...	https://a2.muscache.com/ac/pictures/91338809/e...	https://a2.muscache.com/im/pictures/91338809/e...	https://a2.muscache.com/ac/pictures/91338809/e...	https://a2.muscache.com/ac/pictures/91338809/e...	566102	https://www.airbnb.com/users/show/566102	Eve	2011-05-07	Seattle, Washington, United States	Seattle, WA	within a few hours	100%	100%	t	https://a1.muscache.com/ac/users/566102/profil...	https://a1.muscache.com/ac/users/566102/profil...	Fremont	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	N 44th st, Seattle, WA 98103, United States	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.660856	-122.352401	t	Apartment	Entire home/apt	2	1.0	0.0	1.0	Real Bed	{TV,Internet,"Wireless Internet",Kitchen,Heati...	NaN	$125.00	$888.00	NaN	$150.00	$45.00	1	$0.00	2	1125	3 weeks ago	t	23	53	83	358	2016-01-04	12	2015-08-04	2015-11-29	95.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	2.34
3805	8054902	https://www.airbnb.com/rooms/8054902	20160104002432	2016-01-04	2 BR/1 BA Fremont Apt w/ parking	This 2 bedroom, 1 bath garden-level apartment ...	The Space This 2 bedroom, 1 bath garden-level ...	This 2 bedroom, 1 bath garden-level apartment ...	none	One of the most fun neighborhoods in Seattle. ...	This apartment is located directly below our 1...	Fremont is a great location for visitors looki...	https://a1.muscache.com/ac/pictures/110078306/...	https://a1.muscache.com/im/pictures/110078306/...	https://a1.muscache.com/ac/pictures/110078306/...	https://a1.muscache.com/ac/pictures/110078306/...	4071088	https://www.airbnb.com/users/show/4071088	David	2012-11-05	Seattle, Washington, United States	Hi! My name is David and I currently live in ...	within an hour	100%	100%	f	https://a0.muscache.com/ac/users/4071088/profi...	https://a0.muscache.com/ac/users/4071088/profi...	Fremont	1.0	1.0	['email', 'phone', 'facebook', 'linkedin', 're...	t	t	1st Avenue Northwest, Seattle, WA 98107, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.653158	-122.356285	t	Apartment	Entire home/apt	6	1.0	2.0	2.0	Real Bed	{TV,Internet,"Wireless Internet","Air Conditio...	NaN	$100.00	NaN	NaN	$200.00	$89.00	4	$20.00	2	30	today	t	19	49	79	329	2016-01-04	10	2015-10-21	2015-12-23	98.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	strict	f	f	1	3.95
3806	5458027	https://www.airbnb.com/rooms/5458027	20160104002432	2016-01-04	Sunny Charm in Urban Cottage 2BD	Charming urban home with rustic cottage feel. ...	NaN	Charming urban home with rustic cottage feel. ...	none	NaN	Deb, the cleaning lady & caretaker, will be in...	NaN	NaN	NaN	https://a2.muscache.com/ac/pictures/101952566/...	NaN	6963318	https://www.airbnb.com/users/show/6963318	Grace	2013-06-17	Seattle, Washington, United States	Welcome to Fremont!\n\nI look forward to hosti...	within an hour	100%	100%	t	https://a2.muscache.com/ac/users/6963318/profi...	https://a2.muscache.com/ac/users/6963318/profi...	Fremont	2.0	2.0	['email', 'phone', 'reviews', 'jumio']	t	t	Greenwood Avenue North, Seattle, WA 98103, Uni...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.656057	-122.354514	t	House	Entire home/apt	4	1.0	2.0	2.0	Real Bed	{Internet,"Wireless Internet",Kitchen,Heating,...	NaN	$160.00	NaN	NaN	NaN	$50.00	1	$0.00	1	1125	3 months ago	t	0	0	0	109	2016-01-04	1	2015-08-31	2015-08-31	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	flexible	f	f	2	0.24
3807	4940491	https://www.airbnb.com/rooms/4940491	20160104002432	2016-01-04	Roof Deck in Fremont/Wallingford	Adorable private studio nestled in one of Seat...	The studio is filled with beautiful original a...	Adorable private studio nestled in one of Seat...	none	From the apartment it is an easy walk to the h...	NaN	Public Bus stops right outside the building.	NaN	NaN	https://a2.muscache.com/ac/pictures/63461830/1...	NaN	466499	https://www.airbnb.com/users/show/466499	Elizabeth	2011-03-27	Arlington, Massachusetts, United States	Until last year, I lived in the Boston area, b...	within a day	100%	100%	f	https://a0.muscache.com/ac/users/466499/profil...	https://a0.muscache.com/ac/users/466499/profil...	Wallingford	1.0	1.0	['email', 'phone', 'reviews']	t	f	Stone Way North, Seattle, WA 98103, United States	Wallingford	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.654304	-122.342720	t	Apartment	Entire home/apt	2	1.0	0.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$109.00	NaN	$1,800.00	NaN	$25.00	2	$0.00	1	360	4 days ago	t	4	21	51	325	2016-01-04	7	2015-04-12	2015-10-04	97.0	10.0	10.0	10.0	10.0	10.0	9.0	f	NaN	WASHINGTON	f	strict	f	f	1	0.78
3808	1844791	https://www.airbnb.com/rooms/1844791	20160104002432	2016-01-04	Beautiful Craftsman - Fremont 3 Bed	Our charming home in fabulous Upper Fremont is...	This is a classically beautiful Craftsman home...	Our charming home in fabulous Upper Fremont is...	none	Fremont is wonderful; you will love it here. T...	Normal check-in time is 3-4:00; whenever possi...	The #5 bus is 2 blocks away and it is a 15-20 ...	https://a0.muscache.com/ac/pictures/26113769/f...	https://a0.muscache.com/im/pictures/26113769/f...	https://a0.muscache.com/ac/pictures/26113769/f...	https://a0.muscache.com/ac/pictures/26113769/f...	7964921	https://www.airbnb.com/users/show/7964921	Charlie & Sarah	2013-08-05	Seattle, Washington, United States	Thank you for considering our house for your a...	within a few hours	100%	100%	f	https://a1.muscache.com/ac/users/7964921/profi...	https://a1.muscache.com/ac/users/7964921/profi...	Fremont	2.0	2.0	['email', 'phone', 'reviews', 'kba']	t	t	Dayton Avenue North, Seattle, WA 98103, United...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.662036	-122.350485	t	House	Entire home/apt	6	2.0	3.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$175.00	NaN	NaN	$500.00	$95.00	4	$30.00	3	1125	today	t	19	19	19	294	2016-01-04	29	2013-12-10	2015-10-04	96.0	10.0	9.0	10.0	10.0	10.0	9.0	f	NaN	WASHINGTON	f	strict	f	f	2	1.15
3809	6120046	https://www.airbnb.com/rooms/6120046	20160104002432	2016-01-04	Lake Veiw Cottage in Fremont	From the deck of this quaint little apartment ...	This one bedroom apartment (Hippy Shack) is de...	From the deck of this quaint little apartment ...	none	This cottage apartment is located just a few b...	1. Is the property quite private? ie. can we s...	This cottage apartment is located just a few b...	https://a2.muscache.com/ac/pictures/76273783/b...	https://a2.muscache.com/im/pictures/76273783/b...	https://a2.muscache.com/ac/pictures/76273783/b...	https://a2.muscache.com/ac/pictures/76273783/b...	31752892	https://www.airbnb.com/users/show/31752892	Megan	2015-04-22	Seattle, Washington, United States	NaN	within a day	100%	100%	f	https://a2.muscache.com/ac/users/31752892/prof...	https://a2.muscache.com/ac/users/31752892/prof...	Fremont	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	Albion Place North, Seattle, WA 98103, United ...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.648689	-122.343915	t	Apartment	Entire home/apt	4	1.0	1.0	1.0	Real Bed	{"Wheelchair Accessible",Kitchen,Heating,"Fami...	NaN	$120.00	$600.00	$2,200.00	NaN	$75.00	2	$0.00	4	30	5 months ago	t	30	60	90	365	2016-01-04	10	2015-04-26	2015-08-30	80.0	8.0	7.0	9.0	9.0	9.0	8.0	f	NaN	WASHINGTON	f	strict	f	f	1	1.18
3810	262764	https://www.airbnb.com/rooms/262764	20160104002432	2016-01-04	Fremont Farmhouse	Our 2BR/1 bath home in Fremont's most fun neig...	1200 ft2 2BR, 1 Bath farmhouse with a large, t...	Our 2BR/1 bath home in Fremont's most fun neig...	none	We love that Fremont is so centrally located t...	We have two cats, Polly and Theo. They are ind...	We're centrally located to several bus stops t...	https://a1.muscache.com/ac/pictures/75088108/6...	https://a1.muscache.com/im/pictures/75088108/6...	https://a1.muscache.com/ac/pictures/75088108/6...	https://a1.muscache.com/ac/pictures/75088108/6...	1379138	https://www.airbnb.com/users/show/1379138	Rachel	2011-11-07	Seattle, Washington, United States	We are a professional family with 2 high energ...	within an hour	100%	100%	f	https://a0.muscache.com/ac/users/1379138/profi...	https://a0.muscache.com/ac/users/1379138/profi...	Fremont	1.0	1.0	['email', 'phone', 'linkedin', 'reviews', 'kba']	t	t	N Bowdoin Pl, Seattle, WA 98103, United States	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.654205	-122.352604	t	House	Entire home/apt	5	1.0	2.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	1200.0	$154.00	$1,120.00	$5,500.00	$150.00	$85.00	4	$50.00	2	14	4 days ago	t	13	43	73	227	2016-01-04	5	2015-10-01	2015-12-27	92.0	9.0	8.0	10.0	10.0	10.0	8.0	f	NaN	WASHINGTON	f	strict	f	f	1	1.56
3811	8578490	https://www.airbnb.com/rooms/8578490	20160104002432	2016-01-04	Super Convenient Top Floor Apt	In the true spirit of AirBNB this unit is avai...	The building is older (1970's) so not the mode...	In the true spirit of AirBNB this unit is avai...	none	I am equidistant to Fremont and Wallingford an...	Laundry is available but is $1.75 to wash and ...	How to Get to: UW/Husky Stadium): 10 minute d...	https://a2.muscache.com/ac/pictures/109014114/...	https://a2.muscache.com/im/pictures/109014114/...	https://a2.muscache.com/ac/pictures/109014114/...	https://a2.muscache.com/ac/pictures/109014114/...	11847918	https://www.airbnb.com/users/show/11847918	Ryan	2014-02-01	Seattle, Washington, United States	NaN	within a few hours	100%	100%	f	https://a1.muscache.com/ac/users/11847918/prof...	https://a1.muscache.com/ac/users/11847918/prof...	Fremont	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	Whitman Avenue North, Seattle, WA 98103, Unite...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98103	Seattle	Seattle, WA	US	United States	47.657898	-122.346692	t	Apartment	Entire home/apt	3	1.0	1.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$65.00	NaN	NaN	NaN	$20.00	1	$0.00	1	1125	a week ago	t	2	10	13	221	2016-01-04	2	2015-10-01	2015-10-16	100.0	9.0	8.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	0.63
3812	3383329	https://www.airbnb.com/rooms/3383329	20160104002432	2016-01-04	OF THE TREE & CLOUDS. KID FRIENDLY!	Of the Tree & Clouds' "Roots" apartment is 8 b...	The 1-bedroom, ground-floor Roots apartment is...	Of the Tree & Clouds' "Roots" apartment is 8 b...	none	It's taken me a while to figure out why Fremon...	There is NO television. We do have good WI-FI....	The apartment is easily accessed from I-5 Nort...	https://a0.muscache.com/ac/pictures/108686685/...	https://a0.muscache.com/im/pictures/108686685/...	https://a0.muscache.com/ac/pictures/108686685/...	https://a0.muscache.com/ac/pictures/108686685/...	3443346	https://www.airbnb.com/users/show/3443346	Jacqueline	2012-09-01	Seattle, Washington, United States	I’ve been a landlord (and loved it) for fourte...	within an hour	100%	100%	t	https://a0.muscache.com/ac/users/3443346/profi...	https://a0.muscache.com/ac/users/3443346/profi...	Fremont	3.0	3.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	Northwest 39th Street, Seattle, WA 98107, Unit...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.654516	-122.358124	t	Apartment	Entire home/apt	4	1.0	1.0	2.0	Real Bed	{Internet,"Wireless Internet",Kitchen,"Free Pa...	NaN	$95.00	$600.00	$2,200.00	$500.00	NaN	2	$8.00	3	365	yesterday	t	11	30	43	287	2016-01-04	73	2014-07-08	2015-12-29	96.0	10.0	10.0	10.0	10.0	9.0	10.0	f	NaN	WASHINGTON	t	moderate	t	t	3	4.01
3813	8101950	https://www.airbnb.com/rooms/8101950	20160104002432	2016-01-04	3BR Mountain View House in Seattle	Our 3BR/2BA house boasts incredible views of t...	Our 3BR/2BA house bright, stylish, and wheelch...	Our 3BR/2BA house boasts incredible views of t...	none	We're located near lots of family fun. Woodlan...	NaN	NaN	https://a2.muscache.com/ac/pictures/103217071/...	https://a2.muscache.com/im/pictures/103217071/...	https://a2.muscache.com/ac/pictures/103217071/...	https://a2.muscache.com/ac/pictures/103217071/...	31148752	https://www.airbnb.com/users/show/31148752	Bo	2015-04-13	US	NaN	within a few hours	99%	100%	f	https://a2.muscache.com/ac/users/31148752/prof...	https://a2.muscache.com/ac/users/31148752/prof...	Holly	354.0	354.0	['email', 'phone', 'linkedin', 'reviews', 'jum...	t	t	Northwest 48th Street, Seattle, WA 98107, Unit...	Fremont	Fremont	Other neighborhoods	Seattle	WA	98107	Seattle	Seattle, WA	US	United States	47.664295	-122.359170	t	House	Entire home/apt	6	2.0	3.0	3.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet","A...	NaN	$359.00	NaN	NaN	NaN	$230.00	1	$0.00	3	1125	today	t	18	32	32	32	2016-01-04	1	2015-09-27	2015-09-27	80.0	8.0	10.0	4.0	8.0	10.0	8.0	f	NaN	WASHINGTON	f	strict	f	f	8	0.30
3814	8902327	https://www.airbnb.com/rooms/8902327	20160104002432	2016-01-04	Portage Bay View!-One Bedroom Apt	800 square foot 1 bedroom basement apartment w...	This space has a great view of Portage Bay wit...	800 square foot 1 bedroom basement apartment w...	none	The neighborhood is a quiet oasis that is clos...	This is a basement apartment in a newer reside...	Uber and Car2go are good options in Seattle. T...	https://a2.muscache.com/ac/pictures/626d4b1f-6...	https://a2.muscache.com/im/pictures/626d4b1f-6...	https://a2.muscache.com/ac/pictures/626d4b1f-6...	https://a2.muscache.com/ac/pictures/626d4b1f-6...	46566046	https://www.airbnb.com/users/show/46566046	Glen	2015-10-14	Seattle, Washington, United States	I am a 58 year old male that is married to Mag...	within an hour	100%	100%	f	https://a2.muscache.com/ac/pictures/d7e59b0d-8...	https://a2.muscache.com/ac/pictures/d7e59b0d-8...	Portage Bay	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'jum...	t	t	Fuhrman Avenue East, Seattle, WA 98102, United...	Portage Bay	Portage Bay	Capitol Hill	Seattle	WA	98102	Seattle	Seattle, WA	US	United States	47.649552	-122.318309	t	Apartment	Entire home/apt	4	1.0	1.0	2.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$79.00	NaN	NaN	$500.00	$50.00	3	$25.00	2	29	2 days ago	t	6	26	44	273	2016-01-04	2	2015-12-18	2015-12-24	100.0	10.0	10.0	10.0	10.0	10.0	10.0	f	NaN	WASHINGTON	f	moderate	f	f	1	2.00
3815	10267360	https://www.airbnb.com/rooms/10267360	20160104002432	2016-01-04	Private apartment view of Lake WA	Very comfortable lower unit. Quiet, charming m...	NaN	Very comfortable lower unit. Quiet, charming m...	none	NaN	NaN	NaN	https://a2.muscache.com/ac/pictures/a5974f04-2...	https://a2.muscache.com/im/pictures/a5974f04-2...	https://a2.muscache.com/ac/pictures/a5974f04-2...	https://a2.muscache.com/ac/pictures/a5974f04-2...	52791370	https://www.airbnb.com/users/show/52791370	Virginia	2015-12-30	US	NaN	NaN	NaN	NaN	f	https://a2.muscache.com/ac/pictures/efc75826-1...	https://a2.muscache.com/ac/pictures/efc75826-1...	NaN	1.0	1.0	['phone']	t	f	South Laurel Street, Seattle, WA 98178, United...	NaN	Rainier Beach	Rainier Valley	Seattle	WA	98178	Seattle	Seattle, WA	US	United States	47.508453	-122.240607	f	House	Entire home/apt	2	1.0	1.0	1.0	Real Bed	{"Cable TV","Wireless Internet",Kitchen,"Free ...	NaN	$93.00	$450.00	NaN	$250.00	$35.00	2	$20.00	1	7	4 days ago	t	29	59	88	88	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	moderate	f	f	1	NaN
3816	9604740	https://www.airbnb.com/rooms/9604740	20160104002432	2016-01-04	Amazing View with Modern Comfort!	Cozy studio condo in the heart on Madison Park...	Fully furnished unit to accommodate most needs...	Cozy studio condo in the heart on Madison Park...	none	Madison Park offers a peaceful slow pace upsca...	NaN	Yes	https://a2.muscache.com/ac/pictures/202e4ad6-b...	https://a2.muscache.com/im/pictures/202e4ad6-b...	https://a2.muscache.com/ac/pictures/202e4ad6-b...	https://a2.muscache.com/ac/pictures/202e4ad6-b...	25522052	https://www.airbnb.com/users/show/25522052	Karen	2015-01-03	Tacoma, Washington, United States	NaN	within an hour	100%	NaN	f	https://a0.muscache.com/ac/users/25522052/prof...	https://a0.muscache.com/ac/users/25522052/prof...	NaN	1.0	1.0	['email', 'phone', 'facebook', 'reviews', 'kba']	t	t	43rd Avenue East, Seattle, WA 98112, United St...	NaN	Madison Park	Capitol Hill	Seattle	WA	98112	Seattle	Seattle, WA	US	United States	47.632335	-122.275530	f	Condominium	Entire home/apt	2	1.0	0.0	1.0	Real Bed	{TV,"Wireless Internet",Kitchen,"Free Parking ...	NaN	$99.00	NaN	NaN	$300.00	$45.00	1	$0.00	3	1125	never	t	30	60	90	179	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	moderate	f	f	1	NaN
3817	10208623	https://www.airbnb.com/rooms/10208623	20160104002432	2016-01-04	Large Lakefront Apartment	All hardwood floors, fireplace, 65" TV with Xb...	NaN	All hardwood floors, fireplace, 65" TV with Xb...	none	NaN	Also our puppy will be boarded away.	NaN	https://a2.muscache.com/ac/pictures/596705b3-0...	https://a2.muscache.com/im/pictures/596705b3-0...	https://a2.muscache.com/ac/pictures/596705b3-0...	https://a2.muscache.com/ac/pictures/596705b3-0...	14703116	https://www.airbnb.com/users/show/14703116	Gil	2014-04-25	Seattle, Washington, United States	NaN	within a day	100%	NaN	f	https://a2.muscache.com/ac/pictures/8864f979-b...	https://a2.muscache.com/ac/pictures/8864f979-b...	Queen Anne	1.0	1.0	['email', 'phone', 'reviews', 'kba']	t	t	Westlake Avenue North, Seattle, WA 98109, Unit...	Queen Anne	East Queen Anne	Queen Anne	Seattle	WA	98109	Seattle	Seattle, WA	US	United States	47.641186	-122.342085	t	Apartment	Entire home/apt	3	1.5	2.0	1.0	Real Bed	{TV,"Cable TV",Internet,"Wireless Internet",Ki...	NaN	$87.00	NaN	NaN	NaN	NaN	1	$0.00	1	1125	a week ago	t	7	7	7	7	2016-01-04	0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	f	NaN	WASHINGTON	f	flexible	f	f	1	NaN

	id	scrape_id	host_id	host_listings_count	host_total_listings_count	latitude	longitude	accommodates	bathrooms	bedrooms	beds	square_feet	guests_included	minimum_nights	maximum_nights	availability_30	availability_60	availability_90	availability_365	number_of_reviews	review_scores_rating	review_scores_accuracy	review_scores_cleanliness	review_scores_checkin	review_scores_communication	review_scores_location	review_scores_value	license	calculated_host_listings_count	reviews_per_month
count	3.818000e+03	3.818000e+03	3.818000e+03	3816.000000	3816.000000	3818.000000	3818.000000	3818.000000	3802.000000	3812.000000	3817.000000	97.000000	3818.000000	3818.000000	3818.000000	3818.000000	3818.000000	3818.000000	3818.000000	3818.000000	3171.000000	3160.000000	3165.000000	3160.000000	3167.000000	3163.000000	3162.000000	0.0	3818.000000	3191.000000
mean	5.550111e+06	2.016010e+13	1.578556e+07	7.157757	7.157757	47.628961	-122.333103	3.349398	1.259469	1.307712	1.735394	854.618557	1.672603	2.369303	780.447617	16.786276	36.814825	58.082504	244.772656	22.223415	94.539262	9.636392	9.556398	9.786709	9.809599	9.608916	9.452245	NaN	2.946307	2.078919
std	2.962660e+06	0.000000e+00	1.458382e+07	28.628149	28.628149	0.043052	0.031745	1.977599	0.590369	0.883395	1.139480	671.404893	1.311040	16.305902	1683.589007	12.173637	23.337541	34.063845	126.772526	37.730892	6.606083	0.698031	0.797274	0.595499	0.568211	0.629053	0.750259	NaN	5.893029	1.822348
min	3.335000e+03	2.016010e+13	4.193000e+03	1.000000	1.000000	47.505088	-122.417219	1.000000	0.000000	0.000000	1.000000	0.000000	0.000000	1.000000	1.000000	0.000000	0.000000	0.000000	0.000000	0.000000	20.000000	2.000000	3.000000	2.000000	2.000000	4.000000	2.000000	NaN	1.000000	0.020000
25%	3.258256e+06	2.016010e+13	3.275204e+06	1.000000	1.000000	47.609418	-122.354320	2.000000	1.000000	1.000000	1.000000	420.000000	1.000000	1.000000	60.000000	2.000000	13.000000	28.000000	124.000000	2.000000	93.000000	9.000000	9.000000	10.000000	10.000000	9.000000	9.000000	NaN	1.000000	0.695000
50%	6.118244e+06	2.016010e+13	1.055814e+07	1.000000	1.000000	47.623601	-122.328874	3.000000	1.000000	1.000000	1.000000	750.000000	1.000000	2.000000	1125.000000	20.000000	46.000000	73.000000	308.000000	9.000000	96.000000	10.000000	10.000000	10.000000	10.000000	10.000000	10.000000	NaN	1.000000	1.540000
75%	8.035127e+06	2.016010e+13	2.590309e+07	3.000000	3.000000	47.662694	-122.310800	4.000000	1.000000	2.000000	2.000000	1200.000000	2.000000	2.000000	1125.000000	30.000000	59.000000	89.000000	360.000000	26.000000	99.000000	10.000000	10.000000	10.000000	10.000000	10.000000	10.000000	NaN	2.000000	3.000000
max	1.034016e+07	2.016010e+13	5.320861e+07	502.000000	502.000000	47.733358	-122.240607	16.000000	8.000000	7.000000	15.000000	3000.000000	15.000000	1000.000000	100000.000000	30.000000	60.000000	90.000000	365.000000	474.000000	100.000000	10.000000	10.000000	10.000000	10.000000	10.000000	10.000000	NaN	37.000000	12.150000

	listing_id	id	date	reviewer_id	reviewer_name	comments
0	7202016	38917982	2015-07-19	28943674	Bianca	Cute and cozy place. Perfect location to every...
1	7202016	39087409	2015-07-20	32440555	Frank	Kelly has a great room in a very central locat...
2	7202016	39820030	2015-07-26	37722850	Ian	Very spacious apartment, and in a great neighb...
3	7202016	40813543	2015-08-02	33671805	George	Close to Seattle Center and all it has to offe...
4	7202016	41986501	2015-08-10	34959538	Ming	Kelly was a great host and very accommodating ...
5	7202016	43979139	2015-08-23	1154501	Barent	Kelly was great, place was great, just what I ...
6	7202016	45265631	2015-09-01	37853266	Kevin	Kelly was great! Very nice and the neighborhoo...
7	7202016	46749120	2015-09-13	24445447	Rick	hola all bnb erz - Just left Seattle where I h...
8	7202016	47783346	2015-09-21	249583	Todd	Kelly's place is conveniently located on a qui...
9	7202016	48388999	2015-09-26	38110731	Tatiana	The place was really nice, clean, and the most...
10	7202016	49441269	2015-10-04	39852826	Tim	The place was really nice, clean and quiet at ...
11	7202016	50490194	2015-10-12	384855	Tony	The listing was exactly as described! Kelly's...
12	7202016	53862449	2015-11-13	21607838	Jason	Very welcoming and a nicer place to live in th...
13	7202016	54562283	2015-11-21	17052263	Don	Great location, great price, great host! Thank...
14	7202016	55212826	2015-11-29	4774006	Vivian	Staying at Kelly's was easy. The location was ...
15	7202016	58268184	2016-01-02	41297839	Travis	Kelly was an amazing host who made the stay ve...
16	3946674	20798623	2014-10-05	9313038	Angeline	Despite our late booking request, Rachel & Jon...
17	3946674	21224862	2014-10-13	8385649	Celine	Rachel & Jon have a nice house closed to downt...
18	3946674	22877803	2014-11-16	9403201	Rémy	Rachel and Jon have been the perfect hosts for...
19	3946674	22938377	2014-11-17	2920596	Jason	This house was a delightful bright place to st...
20	3946674	23416253	2014-11-30	23579299	Margit	Beautiful place, nice neighborhood and lovely ...
21	3946674	23463915	2014-12-01	20706964	Ashley	Super cozy home. Located near some good restau...
22	3946674	23709531	2014-12-08	23941301	Tim	Cute house, and Rachel and Jon were super nice...
23	3946674	23961948	2014-12-15	7008965	Gabriel	Rachel and Jon were really great hosts. Warm, ...
24	3946674	24118813	2014-12-20	24025530	Davi	The house was easy to locate and the arrangeme...
25	3946674	24302648	2014-12-25	23834617	Tim	Rachel and Jon were very obliging hosts, super...
26	3946674	25275185	2015-01-11	11109842	Michelle	What a great stay at Rachel and Jon's! They we...
27	3946674	26338015	2015-02-09	9997395	Jack	We had an amazing time and felt very welcome i...
28	3946674	27110794	2015-02-25	4920230	Adrienne	It was very easy to get in touch with Rachel t...
29	3946674	27182900	2015-02-27	3002880	Sasha	Rachel and Jon's home is beautiful and inspiri...
...	...	...	...	...	...	...
84819	3424991	44496259	2015-08-26	42076842	Xu	I had a good experience staying with Michael a...
84820	3424991	46558529	2015-09-11	1339330	Timothy	This was a great place to stay. First off it ...
84821	3424991	47823159	2015-09-21	7583246	Jonah	Awesome location and price. The apartment was ...
84822	3424991	48593190	2015-09-27	30353275	Emiliano	Nice neighbourhood and warm welcome.
84823	3424991	49062311	2015-09-30	26501715	Bronwyn	Great location. I was a little scared to enter...
84824	3424991	52847610	2015-11-02	40018387	Jameson & Michelle	My boyfriend and I had a great experience stay...
84825	3424991	54116274	2015-11-16	21979218	Liam	Had a great stay. Michael and Leah made it re...
84826	3424991	54757263	2015-11-23	30703249	Julia	We had a good stay at Michael. He and Leah pro...
84827	3424991	55074633	2015-11-27	26327758	Tangwei	In big city, it is very hard to find a clean r...
84828	1179538	54492069	2015-11-20	49301240	Francesca	I was searching for a place last minute for my...
84829	1179538	55507128	2015-12-01	49230937	Natalie	Very nice apartment, clean and quite.
84830	3624990	20029700	2014-09-22	6074769	Christie	The location is super convenient to the state ...
84831	3624990	23031040	2014-11-21	19473144	Megan	This apartment is in a great location - easy w...
84832	3624990	27384730	2015-03-03	23852813	Justine	Absolutely perfect stay! Doug & Rebecca were s...
84833	3624990	28773963	2015-03-30	13891549	Cyanide & Happniess	Excellent room, very attentive property manage...
84834	3624990	29827002	2015-04-13	5703826	Janice	Great, clean place in a perfect location for a...
84835	3624990	31793991	2015-05-10	13052628	Jordan	What an amazing place to stay in Seattle! A fe...
84836	3624990	32446221	2015-05-18	24660858	Colleen	We had an excellent stay at Seattle Suites! Th...
84837	3624990	32954604	2015-05-24	22378313	Ryan	The apartment was clean and accurate to the de...
84838	3624990	35297846	2015-06-17	2457555	Sharon	We were warmly greeted by Doug at the time agr...
84839	3624990	36782055	2015-07-01	33029028	Simon	The apartment was clean, tidy and as described...
84840	3624990	42509459	2015-08-14	1329969	Joke	We were with 7 people in rebecca's two 2-bed a...
84841	3624990	46118182	2015-09-08	2005229	Brandon	Great place in the middle of the city. Easy to...
84842	3624990	49000780	2015-09-30	21815461	Kellye	We loved how close it was to the Convention Ce...
84843	3624990	49768901	2015-10-06	37578535	Michael	Comfortability upon arrival and everything wit...
84844	3624990	50436321	2015-10-12	37419458	Ryan	The description and pictures of the apartment ...
84845	3624990	51024875	2015-10-17	6933252	Linda	We had an excellent stay. It was clean and com...
84846	3624990	51511988	2015-10-20	19543701	Jaime	Gran ubicación, cerca de todo lo atractivo del...
84847	3624990	52814482	2015-11-02	24445024	Jørgen	Very good apartement, clean and well sized. Si...
84848	9727246	56429621	2015-12-13	30860360	Stephanie	Breanne was a great host. Check in was easy, s...

	latitude	longitude	neighbourhood	street	listing_id
0	47.636289	-122.371025	Queen Anne	Gilman Dr W, Seattle, WA 98119, United States	241032
1	47.639123	-122.365666	Queen Anne	7th Avenue West, Seattle, WA 98119, United States	953595
2	47.629724	-122.369483	Queen Anne	West Lee Street, Seattle, WA 98119, United States	3308979
3	47.638473	-122.369279	Queen Anne	8th Avenue West, Seattle, WA 98119, United States	7421966
4	47.632918	-122.372471	Queen Anne	14th Ave W, Seattle, WA 98119, United States	278830
5	47.630525	-122.366174	Queen Anne	West Comstock Street, Seattle, WA 98119, Unite...	5956968
6	47.636605	-122.368519	Queen Anne	10th Avenue West, Seattle, WA 98119, United St...	1909058
7	47.640161	-122.375856	Queen Anne	West Wheeler Street, Seattle, WA 98119, United...	856550
8	47.632410	-122.357216	Queen Anne	Queen Anne Avenue North, Seattle, WA 98109, Un...	4948745
9	47.637492	-122.366889	Queen Anne	7th Avenue West, Seattle, WA 98119, United States	2493658
10	47.635482	-122.358478	Queen Anne	1st Ave W, Seattle, WA 98119, United States	175576
11	47.637214	-122.360046	Queen Anne	3rd Avenue West, Seattle, WA 98119, United States	4454295
12	47.635546	-122.373171	NaN	West Howe Street, Seattle, WA 98119, United St...	3883392
13	47.629507	-122.367629	Queen Anne	West Prospect Street, Seattle, WA 98119, Unite...	8889257
14	47.639203	-122.365863	Queen Anne	7th Avenue West, Seattle, WA 98119, United States	5680462
16	47.626200	-122.366602	Queen Anne	West Mercer Place, Seattle, WA 98119, United S...	3245876
17	47.640646	-122.372406	Queen Anne	12th Avenue West, Seattle, WA 98119, United St...	4933447
18	47.639776	-122.372235	Queen Anne	11th Avenue West, Seattle, WA 98119, United St...	7735464
19	47.636025	-122.358694	Queen Anne	1st Avenue West, Seattle, WA 98119, United States	6291829
21	47.636374	-122.361033	Queen Anne	2nd Avenue West, Seattle, WA 98119, United States	4125779
22	47.635632	-122.358881	Queen Anne	1st Avenue West, Seattle, WA 98119, United States	8942678
23	47.633394	-122.371920	Queen Anne	West Galer Street, Seattle, WA 98119, United S...	10106055
24	47.638517	-122.369581	Queen Anne	10th Avenue West, Seattle, WA 98119, United St...	6362362
25	47.631397	-122.367767	Queen Anne	7th Avenue West, Seattle, WA 98119, United States	3544550
26	47.638752	-122.367973	Queen Anne	West McGraw Street, Seattle, WA 98119, United ...	9025039
27	47.639266	-122.374726	Queen Anne	West Wheeler Street, Seattle, WA 98119, United...	3200646
28	47.629907	-122.368948	Queen Anne	9th Avenue West, Seattle, WA 98119, United States	8859380
29	47.639816	-122.374338	Queen Anne	14th Avenue West, Seattle, WA 98119, United St...	4520099
30	47.639008	-122.365320	Queen Anne	7th Avenue West, Seattle, WA 98119, United States	2481869
31	47.635085	-122.364443	Queen Anne	5th Avenue West, Seattle, WA 98119, United States	1110749
...	...	...	...	...	...
3784	47.660342	-122.364747	Fremont	NW 50th St, Seattle, WA 98107, United States	692671
3785	47.653176	-122.346211	Fremont	Bridge Way North, Seattle, WA 98103, United St...	5893969
3786	47.661396	-122.352256	Fremont	Dayton Ave N, Seattle, WA 98103, United States	215954
3787	47.658552	-122.348265	Fremont	Linden Avenue North, Seattle, WA 98103, United...	2494157
3788	47.656739	-122.344865	Fremont	Woodland Park Avenue North, Seattle, WA 98103,...	7745196
3789	47.661171	-122.349923	Fremont	North 46th Street, Seattle, WA 98103, United S...	4645405
3790	47.649271	-122.347817	Fremont	North 35th Street, Seattle, WA 98103, United S...	2755730
3791	47.659149	-122.363466	Fremont	6th Avenue Northwest, Seattle, WA 98107, Unite...	7949448
3792	47.663040	-122.348499	Fremont	North 46th Street, Seattle, WA 98103, United S...	9288840
3793	47.660056	-122.357683	Fremont	Baker Avenue Northwest, Seattle, WA 98107, Uni...	3312406
3794	47.654199	-122.359987	Fremont	Northwest Bowdoin Place, Seattle, WA 98107, Un...	6621924
3796	47.656508	-122.360571	Fremont	NW 40th St, Seattle, WA 98107, United States	609701
3797	47.658976	-122.354915	Fremont	Phinney Avenue North, Seattle, WA 98103, Unite...	10118341
3798	47.655381	-122.343205	Fremont	Midvale Avenue North, Seattle, WA 98103, Unite...	2614387
3799	47.652902	-122.352110	Fremont	Dayton Avenue North, Seattle, WA 98103, United...	7735100
3800	47.663613	-122.349519	Fremont	Linden Avenue North, Seattle, WA 98103, United...	5482204
3801	47.657078	-122.358795	Fremont	1st Avenue Northwest, Seattle, WA 98107, Unite...	4524575
3803	47.661131	-122.349238	Fremont	Linden Avenue North, Seattle, WA 98103, United...	9698202
3804	47.660856	-122.352401	Fremont	N 44th st, Seattle, WA 98103, United States	7178490
3805	47.653158	-122.356285	Fremont	1st Avenue Northwest, Seattle, WA 98107, Unite...	8054902
3806	47.656057	-122.354514	Fremont	Greenwood Avenue North, Seattle, WA 98103, Uni...	5458027
3807	47.654304	-122.342720	Wallingford	Stone Way North, Seattle, WA 98103, United States	4940491
3808	47.662036	-122.350485	Fremont	Dayton Avenue North, Seattle, WA 98103, United...	1844791
3809	47.648689	-122.343915	Fremont	Albion Place North, Seattle, WA 98103, United ...	6120046
3810	47.654205	-122.352604	Fremont	N Bowdoin Pl, Seattle, WA 98103, United States	262764
3811	47.657898	-122.346692	Fremont	Whitman Avenue North, Seattle, WA 98103, Unite...	8578490
3812	47.654516	-122.358124	Fremont	Northwest 39th Street, Seattle, WA 98107, Unit...	3383329
3813	47.664295	-122.359170	Fremont	Northwest 48th Street, Seattle, WA 98107, Unit...	8101950
3814	47.649552	-122.318309	Portage Bay	Fuhrman Avenue East, Seattle, WA 98102, United...	8902327
3817	47.641186	-122.342085	Queen Anne	Westlake Avenue North, Seattle, WA 98109, Unit...	10208623

	host_response_rate	host_acceptance_rate	host_is_superhost	host_thumbnail_url	host_picture_url	host_neighbourhood	host_listings_count	host_total_listings_count	host_verifications	host_has_profile_pic	host_identity_verified
0	96%	100%	f	1	1	Queen Anne	3.0	3.0	[email, phone, reviews, kba]	1	1
1	98%	100%	t	1	1	Queen Anne	6.0	6.0	[email, phone, facebook, linkedin, reviews, ju...	1	1
2	67%	100%	f	1	1	Queen Anne	2.0	2.0	[email, phone, google, reviews, jumio]	1	1
3	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, jumio]	1	1
4	100%	NaN	f	1	1	Queen Anne	2.0	2.0	[email, phone, facebook, reviews, kba]	1	1
5	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
6	100%	100%	t	1	1	Queen Anne	1.0	1.0	[email, phone, reviews, kba]	1	1
7	100%	100%	t	1	1	Queen Anne	5.0	5.0	[email, phone, facebook, google, linkedin, rev...	1	1
8	NaN	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, linkedin, reviews, kba]	1	1
9	98%	100%	t	1	1	Queen Anne	6.0	6.0	[email, phone, facebook, linkedin, reviews, ju...	1	1
10	100%	100%	t	1	1	Queen Anne	1.0	1.0	[email, phone, reviews, kba]	1	1
11	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
12	100%	100%	t	1	1	NaN	1.0	1.0	[email, phone, linkedin, reviews, jumio]	1	1
13	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, reviews, kba]	1	1
14	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
15	100%	100%	f	1	1	NaN	1.0	1.0	[email, reviews, kba]	1	0
16	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, linkedin, reviews, ju...	1	1
17	100%	100%	t	1	1	Queen Anne	1.0	1.0	[email, phone, reviews, kba]	1	1
18	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, jumio]	1	1
19	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, linkedin, reviews, kba]	1	1
20	100%	100%	f	1	1	NaN	1.0	1.0	[email, phone, reviews, kba]	1	1
21	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews]	1	0
22	100%	100%	f	1	1	Queen Anne	1.0	1.0	[phone, reviews]	1	0
23	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[phone]	1	0
24	NaN	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, reviews]	1	0
25	67%	100%	f	1	1	Queen Anne	2.0	2.0	[email, phone, google, reviews, jumio]	1	1
26	100%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, jumio]	1	1
27	100%	100%	t	1	1	Queen Anne	5.0	5.0	[email, phone, facebook, google, linkedin, rev...	1	1
28	100%	100%	f	1	1	Queen Anne	5.0	5.0	[email, phone, reviews, jumio, kba]	1	1
29	71%	100%	f	1	1	Queen Anne	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
...	...	...	...	...	...	...	...	...	...	...	...
3788	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, google, reviews, kba]	1	1
3789	100%	100%	f	1	1	Fremont	2.0	2.0	[email, phone, reviews, kba]	1	1
3790	100%	100%	t	1	1	Fremont	1.0	1.0	[email, phone, reviews, kba]	1	1
3791	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, linkedin, reviews, kba]	1	1
3792	100%	NaN	f	1	1	Fremont	1.0	1.0	[email, phone, kba]	1	0
3793	100%	100%	t	1	1	Fremont	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
3794	80%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, reviews, jumio]	1	1
3795	100%	100%	t	1	1	NaN	1.0	1.0	[email, phone, facebook, reviews, jumio]	1	1
3796	100%	100%	t	1	1	Fremont	1.0	1.0	[email, phone, reviews, jumio]	1	1
3797	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, linkedin, reviews, kba]	1	1
3798	100%	100%	f	1	1	Fremont	2.0	2.0	[email, phone, reviews, kba]	1	1
3799	25%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, reviews, kba]	1	1
3800	NaN	NaN	f	1	1	Fremont	1.0	1.0	[email, phone]	1	0
3801	100%	100%	t	1	1	Fremont	1.0	1.0	[email, phone, linkedin, reviews, kba]	1	1
3802	NaN	NaN	f	1	1	NaN	1.0	1.0	[email, phone]	1	0
3803	97%	100%	f	1	1	Queen Anne	9.0	9.0	[email, phone, facebook, linkedin, reviews, ju...	1	1
3804	100%	100%	t	1	1	Fremont	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
3805	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, facebook, linkedin, reviews, ju...	1	1
3806	100%	100%	t	1	1	Fremont	2.0	2.0	[email, phone, reviews, jumio]	1	1
3807	100%	100%	f	1	1	Wallingford	1.0	1.0	[email, phone, reviews]	1	0
3808	100%	100%	f	1	1	Fremont	2.0	2.0	[email, phone, reviews, kba]	1	1
3809	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
3810	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, linkedin, reviews, kba]	1	1
3811	100%	100%	f	1	1	Fremont	1.0	1.0	[email, phone, reviews, kba]	1	1
3812	100%	100%	t	1	1	Fremont	3.0	3.0	[email, phone, facebook, reviews, kba]	1	1
3813	99%	100%	f	1	1	Holly	354.0	354.0	[email, phone, linkedin, reviews, jumio]	1	1
3814	100%	100%	f	1	1	Portage Bay	1.0	1.0	[email, phone, facebook, reviews, jumio]	1	1
3815	NaN	NaN	f	1	1	NaN	1.0	1.0	[phone]	1	0
3816	100%	NaN	f	1	1	NaN	1.0	1.0	[email, phone, facebook, reviews, kba]	1	1
3817	100%	NaN	f	1	1	Queen Anne	1.0	1.0	[email, phone, reviews, kba]	1	1